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

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 😊

Workflow

Input

Accepted answers

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.

Hope this helps : )

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.

Hope this helps : )

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

Happy to help : ) @acaryasin01

Cheers and have a nice day!