Import Multiple CSVs, reformat data

[DanN]

Hello community

This is my second day using Alteryx and as easy as it is to use, this one is beyond me!

I am attempting to import multiple CSVs and XLS(x) files into one workbook, remove all but 2 fields and create a unique list.

All the files are in the same location and the same formats / headers etc.

I've managed to import and union the files fine, but this isn't giving me a unique list for obvious reasons and exceeds the 1M Excel limit.

What I would like to do is create a unique list using one field from all the files (column C below), then a new column for each file (column D below)

It looks like this, input:

I would like the output to look like this:

Any help would be appreciated

Thank you!

Dan

[grazitti_sapna · Accepted solution]

Hi @DanN ,

What I have understood from your query is a single unique list can have multiple columns. Here is my workflow on the basis of my understanding and sample dataset. Let me know if it helps!

Also, please mark the post as solutions if it works!

Thanks!

[DanN]

Perfect, managed to use this and slightly alter for exactly what I needed :)

[grazitti_sapna]

Glad it helped!