2 Replies Latest reply: Dec 8, 2015 8:59 AM by Olivier Sinquin RSS

    Adding column during/after creating crosstable (script)

      Hi

       

      I am new at Qlikview and need your help for solving a problem.

       

      I am loading a Table A and using the crosstable option.

       

      I also loading a second table B and want to concatenate it with table A.

       

      Table A consists of the Columns C, D, E, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12. (numbers of the months)

       

      Table B consists of the Columns D, E, Date (notice there is no C)

       

      My script looks like:

       

      A:

      Crosstable(Month,Value,3)

      load

      D,

      E,

      2010 as Year,

      1 as Januar,

      2 as Februar,

      3 as März,

      4 as April,

      5 as Mai,

      6 as Juni,

      7 as Juli,

      8 as August,

      9 as September,

      10 as Oktober,

      11 as November,

      12 as Dezember

      from ....

       

      concatenate load

      Date,

      Month(Date) as Month,

      Year(Date) as Year,

      D,

      E

      sql ....

      from ...

       

       

      Now my problem is that I want to add a column "Date" to Table A. The Entries of Date of Table A should look like "01.01.2010", "01.02.2010" ... "01.12.2012".

       

      I tried the method "makedate" but i couldnt find a dynamic expression that works. (e.g. makedate(2010,Month,01))

       

      Anyone got an idea to solve it?