unique ID

[Jackmcc17]

I've been provided with 40 csv files in one folder, all the files are different but contain the same unique ID. Want to pull the unique ID and the data for a particular record into one huge excel doc, each tab would be a different file. what would be the best way to do this on alteryx? 

[binuacs]

@Jackmcc17 use batch macro to get all your file and combine into one file and extract the records you need

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...