Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables. One with Date and associated values of sales. There is another table which has 2 columns : CYDate,PYDate . I need to create new table with columns : CYDate, PYDate,CYValue,PYValue. I am finding it difficult to do the same qlikview. I need to do this at script level only for certain calculations. Can someone guide ?
Souce table 1 :
Date | Sales |
1/1/2014 | 123 |
1/2/2014 | 124 |
1/3/2014 | 125 |
1/4/2014 | 123 |
1/5/2014 | 124 |
1/6/2014 | 124 |
1/7/2014 | 124 |
1/8/2014 | 124 |
1/9/2014 | 124 |
1/10/2014 | 125 |
1/2/2013 | 125 |
1/3/2013 | 125 |
1/4/2013 | 125 |
1/5/2013 | 125 |
1/6/2013 | 125 |
1/7/2013 | 125 |
1/8/2013 | 125 |
1/9/2013 | 125 |
1/10/2013 | 125 |
1/11/2013 | 126 |
Source Table 2:
CYDate | PYDATE |
1/1/2014 | 1/2/2013 |
1/2/2014 | 1/3/2013 |
1/3/2014 | 1/4/2013 |
1/4/2014 | 1/5/2013 |
1/5/2014 | 1/6/2013 |
1/6/2014 | 1/7/2013 |
1/7/2014 | 1/8/2013 |
1/8/2014 | 1/9/2013 |
1/9/2014 | 1/10/2013 |
1/10/2014 | 1/11/2013 |
Required result :
CYDate | NPYDATE | CYSales | PYSales |
1/1/2014 | 1/2/2013 | 123 | 125 |
1/2/2014 | 1/3/2013 | 124 | 125 |
1/3/2014 | 1/4/2013 | 125 | 125 |
1/4/2014 | 1/5/2013 | 123 | 125 |
1/5/2014 | 1/6/2013 | 124 | 125 |
1/6/2014 | 1/7/2013 | 124 | 125 |
1/7/2014 | 1/8/2013 | 124 | 125 |
1/8/2014 | 1/9/2013 | 124 | 125 |
1/9/2014 | 1/10/2013 | 124 | 125 |
1/10/2014 | 1/11/2013 | 125 | 126 |
Thanks,
Sailee
MapSales:
MAPPING LOAD
Date,
Sales
FROM
SourceTable1;
Result:
LOAD
CYDate,
PYDATE as NPYDATE,
applymap('MapSales',CYDate,0) as CYSales,
applymap('MapSales',PYDate,0) as PYSales,
FROM
SourceTable2;
MapSales:
MAPPING LOAD
Date,
Sales
FROM
SourceTable1;
Result:
LOAD
CYDate,
PYDATE as NPYDATE,
applymap('MapSales',CYDate,0) as CYSales,
applymap('MapSales',PYDate,0) as PYSales,
FROM
SourceTable2;