topic Re: combining .qvd files in QlikView

combining .qvd files

Wed, 04 Jun 2014 10:10:16 GMT

i have a .csv file which is been generated daily. i have two issues :

1. i need to convert this .csv file in to qvd

2. after converting i need to keep on adding (combine) these reports daily. i don't want to override the data. i want to keep on adding the new data in to the old data file..

eg:-

date	time	msg_id	dvs_id
2014.06.04	07:23:13	000269246086	1KD3A13800052
2014.06.04	07:23:13	000269246087	1KD3A13800052

date	time	msg_id	dvs_id
2014.06.05	07:23:13	000269246090	1KD3A13800052
2014.06.05	07:23:13	000269246091	1KD3A13800052

date	time	msg_id	dvs_id
2014.06.04	07:23:13	000269246086	1KD3A13800052
2014.06.04	07:23:13	000269246087	1KD3A13800052
2014.06.05	07:23:13	000269246090	1KD3A13800052
2014.06.05	07:23:13	000269246091	1KD3A13800052

i really really would appreciate help in this...

thank you in advance

Re: combining .qvd files

Gysbert_Wassenaar — Wed, 04 Jun 2014 12:54:15 GMT

Simply load the csv data, then append the qvddata and store the result in the qvd again:

Table1:
Load date, time, msg_id, dvs_id from mydailycsv.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate(Table1)
Load date, time, msg_id, dvs_id from Table1.qvd (qvd);

Store Table1 into Table1.qvd;

The first time you run the script you comment out the 4th and 5th line since you don't have a qvd file yet. Afterwards use the full script.

Re: combining .qvd files

fkeuroglian — Wed, 04 Jun 2014 12:58:56 GMT

Hi,

1) load csv and create the qvd

2) you have to use INCREMENTAL LOAD, see this

Incremental Load in QlikView – Part1 | Learn QlikView

good luck

Fernando

Re: combining .qvd files

its_anandrjs — Wed, 04 Jun 2014 13:06:21 GMT

You can also try with first load with QVD

//CSV to QVD Creation

Table1:

Load date, time, msg_id, dvs_id from mydailycsv.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Store Table1 into Table1.qvd;

//After QVD creation comment the script

//Load QVD and Concatenate the CSV

Table1:

Load date, time, msg_id, dvs_id from Table1.qvd (qvd);

Concatenate(Table1)

Load date, time, msg_id, dvs_id from mydailycsv.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Store Table1 into Table1.qvd;

Re: combining .qvd files

Thu, 05 Jun 2014 05:12:02 GMT

actually i have to combine 2 separate .csv files every day a new .csv file will be added to a common folder and that data has to be combine to the initial .qvd.. is that possible with this??

Re: combining .qvd files

Thu, 05 Jun 2014 05:32:56 GMT

this worked for me but can you help me in some way to do the reloading automatically.. as i mentioned before there is a common folder and the .csv file will be replaced with a new one daily with the same name. so concatenation steps would be the same.. so is there any way to do the reload automatically... plz help me if you can it would be much much appreciated...

Re: combining .qvd files

its_anandrjs — Thu, 05 Jun 2014 05:45:01 GMT

If you have QMC then you can schedule the QV application to any time daily and there is many options for this. Or you can use BAT files for reload the application and by the use of task scheduler schedule the QV application at any time but this option where you dont have QMC(Qlikview Management Console).

On the bat file you have to write

c:\Program Files\QlikView\QV.exe" c:\Apps\Sales.qvw

Re: combining .qvd files

Thu, 05 Jun 2014 07:10:03 GMT

i did not understand this how can i schedule using the task scheduler??