Error with LOAD sentence

[#1]

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

[#2]

Do you have code that you can show?

[vupen · Accepted solution]

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

[d_pranskus]

You should use following syntax:

TABLE_1:
Load *
From TABLE_1.qvd (qvd);
TABLE_2:
NoConcatenate Load *
From TABLE_2.qvd (qvd);