Mapping table creation

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

Help

Accepted answers

patrick_digan

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

Find Replace 8-27-17.yxmd

All comments

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 ?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703