Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i did this in my script for create a QVD file:
Buffer
SQL SELECT "DT_DATA",
"N_COLUMN1",
"PUN_COLUMN2"
FROM "XXX_TABLE"."V_PROXYTAB";
With "Buffer" i think QlikView create a Qvd file, but where? i not have the directory C:\ProgramData\QlikTech\QlikView\Buffers
ok, and how can i generate the QVD file to use?
Just add the following pseudo-code to the end of the above template, after the SELECT statement. Every assembly of BigTable from either all Oracle data (because the historical QVD doesn't exist yet) or from part QVD/part Oracle will be written to the Historical QVD.
STORE BigTable INTO HistoricalQVD.QVD (QVD);
It's quite simple:
table:
load * from x;
store table into path\table.qvd (qvd);
Here you will find a lot stuff how to implement incremental loadings with where exists-clauses:
Advanced topics for creating a qlik datamodel
- Marcus
I not understand well.... this is my case with this 2 query, how can i create QVD the first time and how can i load from QVD the second time and after?
This is my script:
CDG_EE:
LOAD ANNO,
"SOMMA_CONTI";
SQL SELECT *
FROM "TABLE_YEAR_16";
LOAD ANNO,
"SOMMA_CONTI";
SQL SELECT *
FROM "TABLE_YEAR_17";
I want put in the QVD file only the first query
Thanks
You could reach it just by loading the 2016 data first, storing the qvd and then commenting it out and loading afterwards the new data and the qvd-data or it could be also done within an if-loop:
CDG_EE:
LOAD ANNO, "SOMMA_CONTI";
SQL SELECT * FROM "TABLE_YEAR_16";
store CDG_EE into TABLE_YEAR_16.qvd (qvd);
CDG_EE:
LOAD ANNO, "SOMMA_CONTI";
SQL SELECT * FROM "TABLE_YEAR_17";
concatenate(CDG_EE)
load * TABLE_YEAR_16.qvd (qvd);
- Marcus
That can be great if i can do an "If" if existing file qvd to load it or load the Sql
Thanks
Yes, in general you could do:
if condition then
load 1
else
load 2
end if
and in your case mybe:
if filetime('path\qvd-file.qvd') > 0 then
...
- Marcus
Hi sorry but CONCATENATE(CDG_EE); command make me an error, it say: not found command concatenate
Did the message really say: "not found command concatenate" or was it rather "not found table CDG_EE"? The first message is unknown for me but the second one (from me mentioned) is quite common and happens if this table didn't exists which for example happens if already a table with this data-structure exists - no new table is created else the new load will be appended. If this didn't help please post your relevant script and a screenshot from the error-message.
- Marcus
I find the solution, the error is concatenate(cdg_ee) it want CONCATENATE before my load table:
concatenate
CDG_EE:
LOAD ...,