Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have the following script that pulls financial data from a QVD I've already built, I need to strip out any value that's been loaded against the current month.
LOAD SchemeNo,
MonthYear,
FUMValue
FROM
UnisureFUM.qvd (qvd);
Basically I'm trying to load everything prior to Feb-2016 (as this is the current month)
Any suggestions as I'm trying a Where clause with a variable I've created and can't get it to work...
May be this:
LOAD SchemeNo,
MonthYear,
FUMValue
FROM
UnisureFUM.qvd (qvd)
Where Num(MonthYear) < Num(MonthStart(Today()));
check whether you field and variable date format are same and then use the where clause this should solve your issue.
Try like this :
Let vCurrentmonth=MonthStart(Today());
LOAD SchemeNo,
MonthYear,
FUMValue
FROM
UnisureFUM.qvd (qvd)
where MonthYear< $(vCurrentmonth)
or
where MonthYear< (vCurrentmonth)
NOTE: Make sure your variable(vCurrentmonth) and the field(MonthYear) are in same format
may be this?
LOAD SchemeNo,
MonthYear,
FUMValue
FROM
UnisureFUM.qvd (qvd) where Num(MonthYear)<>Num(MonthStart(Today()));