Capture data with the same value from multiple source file and extract to new DB

Need help on this.

I have several source file with similar headers, all I want to do is to export those files that have similar values and count the numbers. All data that does not have a value will be omitted from the exported file.

Example:

FILE 1

Name1,98
Name2,99
Name3,94
Name5,90

FILE 2
Name1,98
Name4,97
Name3,94
Name7,88

FILE 3
Name2,99
Name3,94
Name1,98
Name6,90

RESULT should be:

NAME1,98,3
NAME2,99,2
NAME3,94,3

Thanks!

If your files are CSVs and you don't mind some pre-processing - Google CSVFIX - Very useful command line utility

Jan, thank you for the question.
What you need to do is to sort the data first,
group it and count number of values.
Than filter out those records where number of values = 1





The desired result

Actual transformation is attached, extract all files into c:\temp folder and open sample.ats file

Many thanks Mike! This helps a lot.