Extract all the CSV files and Consolidate the data - which contains different fileds.

[Vishwak]

Hi, I want to develop an Alteryx workflow that picks up all the CSV files from a folder. Each file has different field names. My plan is to consolidate all the information in one output.

[alexnajm]

Here is a great article that'll give you a batch macro to work with! The Ultimate Input Data Flowchart

Then you can output to one file afterwards via an Output Data tool

[Qiu]

@Vishwak 
Check the macro made by @mceleavey 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from...

[Vishwak]

Thanks, but i need the solution for different schema (Sheet names and field names  are different). each file having different sheet names and field names.