Skip to content

    • Magic ETL

    Magic ETL

    CONCAT different cells in the same column

    Member
    in Magic ETL

    Hello I have a column let's says its called 'Column A' and it looks like this:

     

    COLUMN A

    1

    2

    3

    4

     

    How do I concat so It shows in the same column like so:

     

    COLUMN A

    1,2,3,4

     

    Is there a beast mode that can help me do that?

    Thanks!

     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Coach

      Google LIST_AGG and GROUP_CONCAT.

       

      Alternatively look at PIVOT / UNPIVOT in a SQL context.  The same thing exists for Magic as Collapse and Uncollapse Columns 

      Jae Wilson
      Check out my 🎥 Domo Training YouTube Channel 👨‍💻

      **Say "Thanks" by clicking the ❤️ in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Domo Employee

      Unfortunately, GROUP_CONCAT() is what you are looking for, but that is not available in a beast mode.

       

      You would need to aggregate COLUMN A in a dataflow using GROUP_CONCAT()

    • Member

      thanks! Any pointers on how to do it?

    • Member

      In case you are still looking for a solution, MAGIC ETL 2.0 now allows for a group_Concat functionality. So just add a group function and add group_concat on the column you want to merge.


      Best,

      TJ

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories