topic Incremential Load with Qualify? in QlikView

Incremential Load with Qualify?

Tue, 27 Jan 2015 10:33:33 GMT

Hey Community,

ive got a question to my script. Iam doing an incremential load from a .foc Data and my QVD Data, then store it in a updated one.

My Code:

QV_Table:

LOAD [attribute],

[attribute],

[..]

From

(txt, utf8, embedded labels, delimiter is ';', msq);

Concatenate

QV_Table:

LOAD Distinct *

FROM

(qvd)

Where not Exists([Primary Key]);

STORE QV_Table into (qvd);

so far it works perfectly and it concatenates my 4 tables into QV_Table.

Now i want to use the Qualify'; method, but when i use it my 5 tables are split [table1], [table2], ....

Can i use Qualify and store my data still in 1 table?

alexandros17 — Tue, 27 Jan 2015 10:45:56 GMT

If your final table is. QV_Table then

try with

qualify *;

QV_Table_Final:

noconcatenate

load * resident QV_Table;

drop table QV_Table;

unqualify *;

Gysbert_Wassenaar — Tue, 27 Jan 2015 10:47:01 GMT

Why would you want to use Qualify anyway? There are almost no excuses for using it. I don't see any need for using it in your case.