Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Facing issues,while using where condition in QVD load,
LET vDate = MakeDate(Year(Today()),Month(Today()),1);
Load * z,y,z,EndDate
from FROM [..\..\Shared QVD\test.qvd] (qvd)
where EndDate >= $(vDate)
Why don't you try this:
FROM [..\..\Shared QVD\test.qvd] (qvd)
where EndDate >= Date(Today());
Or this if you want from the starting of the month:
Where EndDate >= Date(MonthStart(Today()));
load without where condition and then load from resident table using where
TEST:
Load ..
from ..qvd
TEST1:
noconcatenate load *
resident TEST
where Endate>=$(vDate)
drop table TEST
loading from a qvd without where clause will be done by an optimized load which is much faster
(upto 10times faster)
Unfortunately its not working....Is there any issue with the date format of End Date?
Yes how does your EndDate Look? Can you share a screenshot of your EndDate data?
Try this:
where Date(Date#(EndDate, 'MM/DD/YYYY')) >= Date(Today());
Often comparing dates as formatted dates and not as numerical dates can be quite hard to get working correctly.
Try to convert the dates to numerical dates:
LET vDate = MonthStart( Today() );
LET vNumDate = Num( vDate );
LOAD
y,
z,
EndDate
WHERE Num(EndDate) >= $(vNumDate);
Try
where EndDate >= '$(vDate)'
