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?
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |