Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Left Join in Load

Hi,

I have two tables that i want to join together while performing a calculation.

Table 1:

Record ID      Date               ItemID          Quantity     

1                    3/1/2012       A                  3

Table 2:

Effective Date     End Date     ItemID          Price

1/1/2012            12/31/2012     A               $10.00

Desired Result:

Record ID     Date               ItemID     Quantity      Charge (Price*Quality)

1                  3/1/2012            A          3               $30.00

How would I do this in a load statement?

Tags (2)
1 Reply

Re: Left Join in Load

HI,

     Use interval match function..

You can refer about in reference manual or  below posts: 

     http://community.qlik.com/message/192808#192808

     http://community.qlik.com/message/222133#222133

Hope it helps

Community Browser