Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Where it save my QVD files?

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

19 Replies
danosoft
Specialist
Specialist
Author

ok, and how can i generate the QVD file to use?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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);

marcus_sommer

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

danosoft
Specialist
Specialist
Author

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

marcus_sommer

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

danosoft
Specialist
Specialist
Author

That can be great if i can do an "If" if existing file qvd to load it or load the Sql

Thanks

marcus_sommer

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

danosoft
Specialist
Specialist
Author

Hi sorry but CONCATENATE(CDG_EE); command make me an error, it say: not found command concatenate

marcus_sommer

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

danosoft
Specialist
Specialist
Author

I find the solution, the error is  concatenate(cdg_ee) it want CONCATENATE before my load table:

concatenate

CDG_EE:

LOAD ...,