3 Replies Latest reply: Oct 4, 2018 5:26 AM by Alexei Ogrel RSS

    convert a vertical table to horizontal table

    Alexei Ogrel

      Hi Qlik Community,

       

      Can someone assist with the below please?

       

      I have a "vertical" table like this:

      Data Table:

      Ordernumber      OrderLineNumber        Entity          Value

      10000054           1                               artcode        4911731130608

      10000054           1                               amount        3

      10000054           1                               price           7,828

      .......

       

      How to load these data to Qlik as one row:

      Ordernumber        OrderLineNumber      Artcode                 Amount      Price

      10000054             1                             4911731130608      3                7,828

      ...........