topic Re: Qvd creation monthly in App Development

Qvd creation monthly

Raju_6952 — Wed, 04 Sep 2024 16:28:55 GMT

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

Re: Qvd creation monthly

Vegar — Wed, 04 Sep 2024 19:12:01 GMT

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

Re: Qvd creation monthly

Raju_6952 — Wed, 11 Sep 2024 06:05:45 GMT

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