Forum Discussion

Larrie_C's avatar
Larrie_C
New Member
5 years ago
Solved

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 mer...
  • Fowmy's avatar
    5 years ago

    Larrie_C 

     

    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 šŸ™‚

    YouTube  LinkedIn