We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Mapping table creation

rajatsaxena2105
7 - Meteor

Hi all,

 

I have two columns as below

Language IDLanguage Name
1Java
2C++
3PL\SQL
4Python
5C#

 

This is like a mapping table and i know that if i have Language ID as "1" in another table, then i can replace it with "Java" by doing a join on both tables with "Language ID" as the common column.

 

However, i want to achieve this

Language IDLanguage Name
1,2Java,C++

 

How is this possible?

 

Thanks,

Rajat

5 REPLIES 5
patrick_digan
17 - Castor
17 - Castor

@rajatsaxena2105 A summarize tool has the "concatenate" function for strings. You would just need a select tool to change your numerical field to a string. If you don't want to combine all of them (your example just had 1 and 2 combined) then you would just need to add grouping field to account for that. 

rajatsaxena2105
7 - Meteor

Hi Patrick,

 

Thanks for the response; although my output could have multiple combinations like

Language ID
1,2
2,4
3,2
3,4
1,3

 

How do i get the corresponding values for these in the corresponding column ?

patrick_digan
17 - Castor
17 - Castor

@rajatsaxena2105 What about using find replace? I've attached a quick example.

rajatsaxena2105
7 - Meteor

Hi Patrick,

 

This works perfect, but i have to do this for 35 columns, is there a better way of doing this ? maybe with a formula tool or something ?

 

Thanks,

Rajat

patrick_digan
17 - Castor
17 - Castor

@rajatsaxena2105 I would add a record ID and then transpose your data before sending it through the find replace. You can crosstab it back at the end.

Labels
Top Solution Authors