Combine multiple .CSV files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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..!!
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @KP4
So this similar group of 20's do they similar name convention or anything?
How do you distinguish the set.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
