topic Help join QVD with join condition A.x<=B.x in QlikView

Help join QVD with join condition A.x<=B.x

Tue, 21 Dec 2010 11:14:27 GMT

Hi,

I must do the join between 2 tables, A and B, with the join condition (A.x <= B.x) AND (A.y = B.y).

How I can do the condition (A.x <= B.x)?

MyVeryBigTable:

Load a1, a2, ...an, x, y

FROM A.qvd (qvd);

left join

Load b1, b2, ....bn, x, y

FROM B.qvd (qvd);

It's also very important the performance.

Thanks!

Tue, 21 Dec 2010 11:22:59 GMT

Can you try this script.

I hope this can help you

MyVeryBigTable:

Load a1, a2, x, y

FROM A.qvd (qvd);

inner join

Load b1, b2, x as B.x , y

FROM B.qvd (qvd);

Final:
Load
*,
'' as Junk
Resident MyVeryBigTable where x<=B.x;

Drop Table MyVeryBigTable;
Drop Field Junk;