exists condition

[upaliwije]

I have following load syntax

Load

  *

Where NET_PRE=0;

Load Sum(PREMIUM) as NET_PRE,

POL_PERIOD_TO AS PER_TO,

POLICY_NO as PLNO

Resident sales1 Group By POLICY_NO,POL_PERIOD_TO;

sales:

NoConcatenate

Load

  *

Resident sales1 where Exists (PER_TO,POL_PERIOD_TO) AND Exists(PLNO,POLICY_NO)

Can I have two exists conditions like above and is it in order ? If not what is the best alternative

[#2]

Yes You can use, if it works fine...!

[#3 · Accepted solution]

Plz look into the attached app.