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
@gaurisaste Sample workflow attached
@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-Flowchart/tac-p/42273
@binuacs My all files must have the different schema. The field name are different,
My all files have the different schema. The fields name are different,
@gaurisaste batch macro can read files with different schema
could you please help me on the with different schema
Thanks Its working successfully
