topic Regarding Join and Keep in QlikView

Regarding Join and Keep

Fri, 13 Dec 2013 08:42:00 GMT

Hello,

Can we use a Join and keep together. For Eg

Left Join(ABC)

Left Keep(PQR)

Load

from XYZ.qvd(qvd);

Regards

Sumeet

michael_maeuser — Fri, 13 Dec 2013 08:44:37 GMT

as far as is know no.

simply do first the left kepp, then load this table resident and left join it and drop the keep table

michael_maeuser — Fri, 13 Dec 2013 08:45:50 GMT

alternatively do a where exists then you can join it at the same time

Fri, 13 Dec 2013 09:06:49 GMT

Thanks a lottt Michael. Its working fine.

Regards

Sumeet