How to create a batch macro for reading multiple files with different schema

[gaurisaste]

column Hi Team,

I have 1 excel sheet it contain all the input files path and sheet name, how I can read that files into macro as 1 by 1

[binuacs]

@gaurisaste use batch macro, you can find the details in the below post, instead of directory tool use your input file, which has the file path and sheet name 

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

[gaurisaste]

@binuacs   My all files must have the different schema. The field name are different,

[gaurisaste]

My all files have the different schema. The fields name are different,

[binuacs]

@gaurisaste batch macro can read files  with different schema 

[gaurisaste]

could you please help me on the with different schema

[binuacs · Accepted solution]

@gaurisaste Sample workflow attached

[gaurisaste]

Thanks Its working successfully