Incremential Load with Qualify?

[#1]

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 · Accepted solution]

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]

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.