7 Replies Latest reply: Mar 27, 2018 9:58 AM by Vijayanth Radha RSS

    Help in pivoting data during load

    Vijayanth Radha

      Can someone please help me to make the following transformation in QlikSense?

       

      I like to transform Table 1 to Table 2's format:

       

      TABLE 1:

       

      Company

      Type

      Value

      COMP1

      CITY

      CITY1

      COMP1

      CITY

      CITY2

      COMP1

      STATE

      STATE1

      COMP1

      COUNTRY

      COUNTRY1

       

      TABLE 2:


      Company

      CITY

      STATE

      COUNTRY

      COMP1

      CITY1

      STATE1

      COUNTRY1

      COMP1

      CITY2

      STATE1

      COUNTRY1

       

      Thanks