Mapping table creation

[rajatsaxena2105]

Hi all,

I have two columns as below

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

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 ID	Language Name
1,2	Java,C++

How is this possible?

Thanks,

Rajat

[patrick_digan]

@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]

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 · Accepted solution]

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

[rajatsaxena2105]

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]

@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.