Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Names in different columns based on ids

Vapour02
8 - Asteroid

Hello all experts, hope you all are doing well.

I'm stuck on something and need some help.

 

I have a data with ids in multiple columns and I need to add a seperate column beside each id column to map their respective names from a different excel sheet.

 

I have added a sample data for reference. 

Please provide a solution and let me know if any more information is required. 

Thank you.

2 REPLIES 2
Mathias_Nielsen
9 - Comet

Hi @Vapour02 ,

 

Try this and see if it works for you :)

 

Raj
16 - Nebula

@Vapour02 
you just need to use join tools to get this output but you need to change the name of second ID and second Name column as you can not have duplicate headers for multiple columns on Alteryx

hope this helps

Labels
Top Solution Authors