7 Replies Latest reply: May 8, 2017 5:46 AM by Martin Mahler RSS

    Qlik Sense - Split one filed in multiple fileds

    Andrea Giacomello

      Hello experts!

      As a result of a REST connection, I have this table:

       

      Field1RowNo
      abc

      1

      asdfg1

      50%

      1
      311
      abd2
      zxcv2
      25%2
      512

       

      The first field should be in 4 different fields, with the RowNo indicatind the number of the row.

       

      How can I transform the table into something like this?

       

      F1F2F3F4
      abcasdfg

      50%

      31
      abdzxcv25%51

       

      Thank you very much!