5 Replies Latest reply: Jul 17, 2017 4:52 AM by Martin Pohl RSS

    Combining Dimensions into one

    Jun Hyuk Ahn

      What I did:

       

      DataTable:

      Load

           Name,

           ID1 &

           ID2 &

           ID3 as ID

      From DataSource

       

      I have also tried inputting separator in-between (ID1&'|'&ID2)

       

      IF ID1~3 are in format: 12-123456

       

      then the first method gave me

          

      NameID
      John Doe12-12345612-12345612-123456

       

      whereas the second method gave me

      NameID
      John Doe12-123456|12-123456|12-123456

       

      However, I want the table to do this:

       

      NameID
      John Doe12-123456
      John Doe12-123456
      John Doe12-123456

       

      Thanks