topic Load Table based on Conditions in QlikView

Load Table based on Conditions

qlikwiz123 — Sat, 16 Nov 2024 17:32:05 GMT

I need to load data from a table based on multiple conditions.

Load Data only if the ID>0 and Not (Tagged=No and Reg_Date<=Today)

How do I combine Where and Where Not in the same Load Script table condition? Also, Not (Tagged=No and Reg_Date<=Today) means, DO NOT Load if both conditions are met, not either or. How do I combine these two conditions and load data?

Re: Load Table based on Conditions

skamath1 — Wed, 03 Feb 2021 02:05:53 GMT

Below is the script

Let vToday = Date(Today(),'M/D/YYYY') ;

LOAD ID,
Tagged,
Reg_Date
FROM
[Test.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where ID > 0 and Not (Tagged = 'No' and Date(Reg_Date,'M/D/YYYY') <= '$(vToday)' ) ;

Re: Load Table based on Conditions

skamath1 — Wed, 03 Feb 2021 02:07:39 GMT

I tested with below sample data in Test.csv file

ID, Tagged,Reg_Date
1, Yes,3/1/2021
2, No, 1/20/2021
0, No, 2/28/2021
3, Yes,1/10/2021

Re: Load Table based on Conditions

MayilVahanan — Wed, 03 Feb 2021 02:08:50 GMT

Hi @qlikwiz123

Try like below

Load * from ursource where ID>0 and Not (Tagged='No' and floor(Reg_Date)<= floor(Today()));