How do I use NONCONCATENATE?

[alan_grn]

I am trying to use the NONCONCATENATE keyword but get an error on load. Can you sue this with eitehr a load or a select statement?

I am trying to use it with a load statement where I am loading from a QVD.

[Miguel_Angel_Baeyens · Accepted solution]

Hello Alan,

You should use something like

Table1:LOAD Field1, Field2 FROM wahtever; Table2:NOCONCATENATE LOAD Field1, Field2 FROM whatever;

[peter_turner]

Hi,

This is a spelling mistake in the manual, should be noconcatenate (no instead of non)
I've been caught out by this before, make sure the command goes blue in the script so QV knows its a script command.
You can add this before your load command to stop the new data being added to an existing table that has the same format.

Or you can load an extra dummy field with your data to make this new table unique such as:
load
*,
1 as dummy_field
from xyz

Peter.

[alan_grn]

Thanks this is the explanation that I was looking for. I was using NON and could not understand why it was not turning blue.

Have tried NONCONCATENATE and it works.