Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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!