How to combine multiple values for one item separated by a coma

Roman_K
Roman_K Member
in SQL DataFlows

There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a comma (shown at the bottom).

Item Number

PO Number

63631

235084

63631

231656

63631

227775

63631

235084

63631

231656

63631

227775

Item Number PO Number

63631 235084, 231656, 227775, 235084, 231656, 227775

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You can do this in Magic ETL with the group by tile and using the group_concat function.

    image.png

    Results in this:

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You can do this in Magic ETL with the group by tile and using the group_concat function.

    image.png

    Results in this:

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Utz
    Utz Member

    @MarkSnodgrass I had a follow-up question on this same question is there any way to achieve this same solution via beast mode? I am having a tough time using the magic etl tool.

Categories