Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to eliminate data on basis of NOT Match function but i am not getting expected results.
Lets say my code is
LET Var1 = Today()- 1;
Load * from XYZ.QVD
Where Not mact (Date1, '$(Var1)')
But still I am getting Today()- 1 data.
Even if write like:
Load * from XYZ.QVD
Where Not mact (Date1, '11/23/2014').
Still I am getting 11/23/2014 data.
The way I am eliminating With Not match is correct? or is there an another way?
BR ,
Neehu
Try this:
LET Var1 = num(Today() - 1);
Load * from XYZ.QVD
Where num(Date1) <> $(Var1);
Try this:
LET Var1 = num(Today() - 1);
Load * from XYZ.QVD
Where num(Date1) <> $(Var1);
HI Gysbet,
WHat if I want to eliminate two dates with two variables?
Use two clauses: Where ...condition1... or ...condition2...
Cant I use like this:?
LET Var1 = NUm(Today()- 1);
LET Var2 = Num(Today()- 2);
Load * from XYZ.QVD
Where Not match (Date1, '$(Var1)', '$(Var2)')
Hi, are you sure about the date format stored in xyz.qvd?
If it's not MM/DD/YYYY (maybe Date1 also has the time part?) you can try:
Load * from XYZ.QVD
Where Not match (Date(Date1, 'MM/DD/YYYY'), '11/23/2014').
Maybe. It depends on the format of the Date1 field. You may have to use the date function as Ruben Marin says above.