5 Replies Latest reply: Sep 8, 2017 2:05 AM by Shraddha Gajare RSS

    Create Table in script

    Tom Hovens

      Hi Qlik'ers

       

      I load the following table (table A) and want it to convert to table B in the script of Qlikview.

       

      I was thinking about the crosstable function but that doesn't work (with the knowlegde I have)

       

      Does anyone has an idea?

       

      Table A

      ItemProjectQuantityStart DateEnd Date
      XA101 - 09- 201705 - 09 - 2017
      YA201 - 09- 201705 - 09 - 2017
      XB202 - 09- 201704 - 09 - 2017

       

       

      Table B

      ItemProjectQuantityDate
      XA101 - 09 - 2017
      XA102 - 09 - 2017
      XA103 - 09 - 2017
      XA104 - 09 - 2017
      XA105 - 09 - 2017
      YA201 - 09 - 2017
      YA202 - 09 - 2017
      YA203 - 09 - 2017
      YA204 - 09 - 2017
      YA205 - 09 - 2017
      XB202 - 09 - 2017
      XB203 - 09 - 2017
      XB204 - 09 - 2017