Reading Multiple Excel files from the folder

[NiranjanK1]

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

[Hamder83]

Does all the file in a folder have the same structure?

[NiranjanK1]

Yes all Excel files only

[binuacs]

@NiranjanK1 @Use the batch macro, the below post might helpful for your usecase 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Using-Directory-tool-to-upload...

[Hamder83]

You can use dynamic input:

[Raj]

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.

[NiranjanK1]

@Hamder83 Im getting error message "The file has different schema than the first file in the set"

any suggestions please .

[NiranjanK1]

@Raj Yes im using Directory tool and Dynamic input tool,  but still im getting some error 

[Hamder83]

Then the headers has to be different or the sheet names between the files?

[Hamder83 · Accepted solution]

Hi 

Alternativly this could work :) just remove the filter on sheetnames :)