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
Solved! Go to Solution.
@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.
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 ?
@rajatsaxena2105 What about using find replace? I've attached a quick example.
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
@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.
User | Count |
---|---|
63 | |
28 | |
23 | |
23 | |
22 |