Qvd creation monthly

[Raju_6952]

Hi,

I have in requirement in qliksense that I have CSV files uploaded in source path for each day now my requirement is that from that files it should create qvd for each month dynamicalyy for example if it has csv files for 31 days then it should load and store that data into same qvd if that files are for August month then it should store as 202408.qvd(qvd) and if files are available for next month then it should create qvd for that month like 202409.qvd(qvd) and when the files for other dates in September updated then it should concatenate to the September qvd only.

Regards,

Raju

[Vegar]

A simple solution could be to do something like this:

Data: Load MonthField, FieldA, FieldB,...,FieldZ From lib://source/*.csv (txt);

For each _month in fieldvaluelist('MonthField')

MonthData:

NoConcatenate LOAD * Resident Data

where MonthField= $(_month);

Store  MonthData into MyQVD_$(_month).qvd (qvd);

Drop table MonthData;

Next _month

[Raju_6952]

Hi @Vegar ,

its not working as expected Its loading data fir several csv files but stroing in  a single qvd not dynmaically for each month.

Regards,

Raju