I am unable to store Qvd based on Yearmonth.
STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);
Is this a field name?
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?
Yes DATEOFTXN is a fieldname and it has multiple values.
May be try this
LOAD Date(MonthStart(DATEOFTXN), 'YYYYMMM') as MonthYear
LET vYearmonthstore = Peek('MonthYear');
Thank u so much.
Retrieving data ...