Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Left Join in Load


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


     Use interval match function..

You can refer about in reference manual or  below posts: 



Hope it helps

Community Browser