Combine multiple .CSV files

Question

Hi All, i am new to Alteryx. I would really appreciate if someone can help.

I have multiple .csv files (approx 60), all without Headers. Out of those 60; 20 files are of one type with similar data, next 20 files consists of another Set of data, and same goes for the last 20.

Now, i want to either combine all these 60 files into one, post which i can apply formula on one field to separate each of these files.
OR If there is any way i can combine one set of similar files into one group and another similar set of files in another group.

Thank in Advance..!!

atcodedog05 · Answer

Hi @KP4

Also, You can take a look at this.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Reading-multiple-CSV-files-at-once/ta-p/38221

Emil_Kos · Answer

Hi @KP4,

I am not sure if there is a way to identify which files are which files without opening them.

If they have different naming convention then in that case you can do that and group them using this knowledge.

2 examples of different naming convention below:

* will replace all rest of the file name.

So lets imagine you got

Data products 2020.10.01.xlsx

Data products 2020.10.02.xlsx

Data products 2020.10.01.xlsx

You can input all of them using Data products*.xlsx

If you aren't able to do do that just get all the data inside one file and choose output file name as a field. Afterwards you will be able to prepare the data sets you required.

Hope this helps.

atcodedog05 · Answer

Hi @KP4

So this similar group of 20's do they similar name convention or anything?

How do you distinguish the set.