Filter and transpose data

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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;

[#3]

Thanks Gysbert.