Hello,
I have a list of CSV (10+) files (i.e. A001.csv-A180), all of which contain data in column 13. I'm interested in doing the following:
1. Output a list of records from file 1 which are present in other files along with the file names where these records are found.
Example of output for file 1. (A001_recurring.csv)
best day A002.csv
best day A003.csv
etc
Example of output for file 2. (A002_recurring.csv)
best day A001.csv
best day A003.csv
etc
Join all recurring files to create a main document.
Thank you