How to create Year Month wise Qvd dynamically

[Naps_230]

Hi,

I have requirement to create year wise qvd dynamically.

EX:-if Source file:-  Market.xls

In Market file have contain multiple year (Like year field contain 2010 to 2019 )

So i need to create qvd like :- Market_2010_Jan.qvd,...Market_2011.qvd_Jan,....Market_2019_Dec.qvd

[Vegar]

Exceldata:

Load 

Date(monthname(Date), 'YYYY_MM') AS Period

Date,

Field,

Value 

From excel.xlsx;

For each _period in fieldvaluelist('Period')

SingleMonthData:

NoConcatenate Load Date, Field, Value

Resident ExcelData 

Where Period = $(_period);

Store SingleMonthData into Marked_$(_period).QVC (qvd);

Drop table SingleMonthData;

Next

[Brett_Bleess]

See duplicate post for solution: https://community.qlik.com/t5/New-to-QlikView/How-to-create-Year-wise-Qvd-dynamically/m-p/1637440#M3...

Regards,
Brett