We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reading Multiple Excel files from the folder

NiranjanK1
8 - Asteroid

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

11 REPLIES 11
Hamder83
11 - Bolide

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

NiranjanK1
8 - Asteroid

Yes all Excel files only

binuacs
21 - Polaris
Hamder83
11 - Bolide

You can use dynamic input:

Hamder83_0-1687332399081.png



Raj
16 - Nebula

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
8 - Asteroid

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

any suggestions please .

NiranjanK1
8 - Asteroid

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

Hamder83
11 - Bolide

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

 

Hamder83
11 - Bolide

Hi 

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

 

Labels
Top Solution Authors