Hi All,
How can i read multiple excel files from the folder. On daily basis we are replacing files in same folder, I need to read all the files available in the folder. Any suggestions how can i build workflow.
Thanks In Advance,
niranjan
Solved! Go to Solution.
Does all the file in a folder have the same structure?
Yes all Excel files only
@NiranjanK1 @Use the batch macro, the below post might helpful for your usecase
Use the Directory tool to do so.
or
suppose you have files such as 10june_2022,11june_2022,12juen_2022
bring an input tool and select any one file suppose 10june_2022 then replace 10june by *
this will make the process automatic all the files form this folder with this syntex will be fetched into designer
Hope this helps.
@Hamder83 Im getting error message "The file has different schema than the first file in the set"
any suggestions please .
@Raj Yes im using Directory tool and Dynamic input tool, but still im getting some error
Then the headers has to be different or the sheet names between the files?