Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Where not Exists([Primary Key]);
STORE QV_Table into
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?
If your final table is. QV_Table then
try with
qualify *;
QV_Table_Final:
noconcatenate
load * resident QV_Table;
drop table QV_Table;
unqualify *;
If your final table is. QV_Table then
try with
qualify *;
QV_Table_Final:
noconcatenate
load * resident QV_Table;
drop table QV_Table;
unqualify *;
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.