topic Re: Left Join & Left Keep in same Load statement in QlikView

Left Join & Left Keep in same Load statement

Fri, 13 Dec 2013 08:35:11 GMT

Hi All,

I have one more question. Can I have a Left Join & Left Keep in the same Load statement.

Eg.

Left Keep (ABC)

Left Join (XYZ)

Load

E, F, G

From OPQ.QVD(qvd);

hic — Fri, 13 Dec 2013 08:44:25 GMT

No. You will need a "Where Exists()" instead, e.g.

Left Join (XYZ)

Load

E, F, G

From OPQ.QVD(qvd)

Where Exists(E);

HIC

Fri, 13 Dec 2013 08:58:50 GMT

The Exists Works seamlessly ... I was just curious if Keep & Join will work or not as it does not throw a syntax error ...

Thanks !!!