I have a SQL query that brings a field called "Year" with multiple values (for example, 2012, 2013, 2014). I would to generate various QVD files, one for each year. Does anyone have any examples of how to do this?
Thanks in advance!!
Try something like:
FOR vYear=2012 TO 2014
LOAD * FROM yourtable WHERE Year = vYear;
STORE TempTable INTO '$(vYear)'.qvd (qvd);
Update: Not sure if in the WHERE clausule you nedd Year = vYear or Year = $(vYear)
Retrieving data ...