Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
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
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;
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.
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
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;
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??
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...
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
i did not understand this how can i schedule using the task scheduler??