Consolidating multiple CSV files

[SahadhKuruniyan]

I have received 20 CSV files from database which has same column headers. I need to consolidate it. It has different schema.

can anyone of you help me to create a macro to consolidate this. that would be biggest help!

[atcodedog05]

Hi @SahadhKuruniyan 

Can you provide 2 sample files to work with.

Happy to help 🙂

[messi007]

@SahadhKuruniyan,

Please see below see the link below. It will help you to read many files at once.

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

Regards,

[atcodedog05]

Hi @messi007 

That guide sadly only covers reading excel 😶

[messi007]

@atcodedog05,

Yup but you can adapte the macro Batch to read a CSV instead of Excel.

Below an example :

1- Batch macro to read a csv 

2- Call CSV with different schema 

Attached the workflow and the macro.

Regards,