Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

input multiple excel files

lalitkumarnaidu
6 - Meteoroid

I have a list of 12 excel files in a folder. The names of these excel files change every day but the schema remains the same.

Can you please help me with how I can read all the files along with their file names?

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @lalitkumarnaidu 

 

You can refer this article it will help you in this scenario.

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

 

Hope this helps : )

JagdeeshN
12 - Quasar
12 - Quasar

Hi @lalitkumarnaidu ,

 

You can do this by configuring the input tool in Alteryx.

1. Use the *.xlsx for reading all the files in the folder.
2. Enable the 'Output File Name as Field' option to get the file names.
Please find attached a sample workflow.

 

Best,
Jagdeesh

lalitkumarnaidu
6 - Meteoroid

thanks jagdeeshn, your answers always works for me 🙂

JagdeeshN
12 - Quasar
12 - Quasar

@lalitkumarnaidu  :- Thanks!. Glad it worked.

niceblue
5 - Atom

Jagadeesh - This works like a charm if the schema is same and the data starts from 1st row itself. What do I do if I have my data starting from 10th or 11th etc., ? I noticed that *.xlsx picks only one file even if I specified the row number in "Start Data Import on Line" and skips the subsequent files.

Labels