Facing Problem in script with Record filtering

Wed, 14 May 2014 11:00:12 GMT

Hi,

I have a requirement to fetch data from DB with multiple condition.I need the records with Flag='Y' and 'N' as well and for Flag=N, only Max(MD_DATE) is required.

1) I need to Fetch FIRST_NAME, LAST_NAME, CITY, ZIP_CODE, CUSTOMER_ID, MANUAL_FLAG, DB_ACTIVE_FLAG

from the DB WHERE (DB_ACTIVE_FLAG='Y' OR DB_ACTIVE_FLAG='N') AND MANUAL_FLAG='Y' (Max(MD_DATE);

Could anyone help me on this?

Thanks in advance.

Re: Facing Problem in script with Record filtering

Anonymous — Wed, 14 May 2014 11:03:45 GMT

I would suggest a two step load:

1) load from database with the first condition

2) concatenate load with the second condition

In this scenario you cantest the two loads separately and you do not need to know exactly the syntax

of the combined condition!

topic Re: Facing Problem in script with Record filtering in QlikView

Facing Problem in script with Record filtering

Re: Facing Problem in script with Record filtering