Left Join & Left Keep in same Load statement

[#1]

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]

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

[#3]

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

Thanks !!!