Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

which tool can I use to combine 6 columns of part numbers into one column

MikeFrancis1959
8 - Asteroid

I have an Excel file that has 6 or more columns of parts numbers based on a customer. Some of them may be the same and some may not and I would like to create a workflow that can take all the columns and create a new one. I have to do this monthly and the original file from Excel is already in Alteryx but using different tabs of data so using Alteryx bet better, what is the best tool to use?

Thanks,

Mike

 

5 REPLIES 5
ScottLewis
11 - Bolide

Can you show what the output should look like for your sample data? Combine can mean a lot of things. 

binu_acs
21 - Polaris

@MikeFrancis1959 Something like this?

binuacs_0-1687279048399.png

 

MikeFrancis1959
8 - Asteroid

Here is my file again with an example output. My end goal is to take all of the part numbers from all the customers and put them in one column whether they are duplicated or not. I can then remove the duplicates but this is what I am trying to do.

Mike

binu_acs
21 - Polaris

@MikeFrancis1959 Updated workflow attached

binuacs_0-1687283461740.png

 

MikeFrancis1959
8 - Asteroid

I was expecting something more complex but you made this very easy, again thank you for your help on this workflow and others I have asked about!!!!

Labels
Top Solution Authors