Reading multiple csv file at once by adding ID or special character to each file's own row

[acaryasin01]

Hi Guys,

I have more than 2 csv files and I want to open these files at once. 

After exporting all files to the one table I also would like to see which row belongs to which file in this table?

Any idea will be appreciated 😊

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

Here is how you can do it.

Workflow:

1. You can read multiple .csv file at a time using regex wildcard in filename.

2. You can configure input tool to output filename.

Resource on reading multiple files at a time https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480 

Hope this helps : )

[acaryasin01]

Thank you so much @atcodedog05 for your flash 😎 and detailed respond

[atcodedog05]

Happy to help : ) @acaryasin01 

Cheers and have a nice day!

[atcodedog05]

Hi @acaryasin01 

And thank you I just ranked up to Rank - 20 🙂 😇