topic How to create Year Month wise Qvd dynamically in QlikView

How to create Year Month wise Qvd dynamically

Naps_230 — Sat, 19 Oct 2019 11:53:50 GMT

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 — Sat, 19 Oct 2019 18:26:37 GMT

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;

Brett_Bleess — Tue, 29 Oct 2019 11:52:32 GMT

Regards,
Brett