input multiple excel files

[lalitkumarnaidu]

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?

[atcodedog05 · Accepted solution]

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 · Accepted solution]

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]

thanks jagdeeshn, your answers always works for me 🙂

[JagdeeshN]

@lalitkumarnaidu  :- Thanks!. Glad it worked.

[niceblue]

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.