Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having problems on load Files.
I have a function that:
1. Load a qdv file
TABLENAME << x Records
2. For each txt file do ...
Here is where I have the problem.
After LOAD I have writed table name to load. TABLENAME_2 (It's an example), but when the system loads, it's writing records on qvd tablename, that has the same structure that tablename_2.
TABLENAME_2:
LOAD
...
I get TABLENAME << x+new one records. and I want TABLENAME_2 << x records
I don't want to load data on tablename, I want to load it on TABLENAME_2.
Can someone help me
When 2 tables that have same column structure are loaded, QV automatically joins the second into the first table.
To avoid it, use the directive [no concatenate] telling QV not to concatenate.
Ex:
TABLE_1:
Load
Select *
From
TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load
Select *
From
TABLE_2.qvd (qvd);
Do you have code that you can show?
When 2 tables that have same column structure are loaded, QV automatically joins the second into the first table.
To avoid it, use the directive [no concatenate] telling QV not to concatenate.
Ex:
TABLE_1:
Load
Select *
From
TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load
Select *
From
TABLE_2.qvd (qvd);
You should use following syntax:
TABLE_1:
Load *
From TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load *
From TABLE_2.qvd (qvd);