Forum Discussion
merge column with delimited values without splitting
Hey everyone,
I have the folowing data:
| a | 100 |
| b | 100, 101, 102 |
| c | 102,103 |
| d | 102 |
And ID's
| 100 | yellow |
| 101 | blue |
| 102 | green |
| 103 | purple |
Is there a way to merge the colors into the first table, without having to delimit them an joining together after merging each column?
The endresult should look like this:
| a | yellow |
| b | yellow, blue, green |
| c | green, purple |
| d | green |
Thanks
That is the way to go but after you merge with the color table, then you can use the group function concatenate the colors the first column.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
2 Replies
That is the way to go but after you merge with the color table, then you can use the group function concatenate the colors the first column.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
