Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am unable to store Qvd based on Yearmonth.
LET vYearmonthstore=Year(DATEOFTXN)&Month(DATEOFTXN);
STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);
May be try this
Fact:
LOAD ...,
DATEOFTXN
FROM ....;
MonthYear:
LOAD Date(MonthStart(DATEOFTXN), 'YYYYMMM') as MonthYear
Resident Fact;
LET vYearmonthstore = Peek('MonthYear');
STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);
Is this a field name?
DATEOFTXN
If it is, then you can't really use this directly in LET ... Can you let us know if DATEOFTXN has single value or multiple values?
Dear Sunny,
Yes DATEOFTXN is a fieldname and it has multiple values.
DATEOFTXN
2018-06-25 00:00:00:000000
2018-06-24 00:00:00:000000
2018-06-23 00:00:00:000000
Regards,
Joshua.
May be try this
Fact:
LOAD ...,
DATEOFTXN
FROM ....;
MonthYear:
LOAD Date(MonthStart(DATEOFTXN), 'YYYYMMM') as MonthYear
Resident Fact;
LET vYearmonthstore = Peek('MonthYear');
STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);
Dear Sunny,
Thank u so much.
Regards,
Joshua.