How to read multi file from folder with difference schema

[patcharika]

Ex. input

after read all file output is :

if you want to input data with multi file. you can use directory to connect your folder. picture above is use case on my work. Actually, you can use  macro to read multi file and in my logic is compare column first and select file that have column more than another file to read fist and then use macro2 for read file again

read file difference schema for finding file that have column more than another file

after you know file that have most column you can read file manage by macro read by column name 

ps. im sorry with my English is not good but I just want to share. I thought that would be useful.😁

[BrandonB]

Thank you for sharing @patcharika! 

Here is one of my favorite articles on different considerations when ingesting data of different schemas: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

And a helpful macro that can read in directories of files easily with a nice interface: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...