topic Re: Where condition from another table column in QlikView

Where condition from another table column

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please help in the below scenario:

Load A1,A2,A3 from A

I want to load B in such a manner -

Load B1,B2,B3 from B where B1 = A1

I tried the above way but it is showing A1 column not found.

Please help how to achieve the above.

Thanks,

Girish Inani

sunny_talwar — Tue, 08 Nov 2016 12:00:54 GMT

May be use Where Exist here:

LOAD A1,

A2,

FROM A;

LOAD B1,

B2,

FROM B

Where Exists(A1, B1);