topic How do I use NONCONCATENATE? in QlikView

How do I use NONCONCATENATE?

alan_grn — Mon, 22 Mar 2010 09:24:01 GMT

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.

How do I use NONCONCATENATE?

Miguel_Angel_Baeyens — Mon, 22 Mar 2010 09:34:47 GMT

Hello Alan,

You should use something like

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

How do I use NONCONCATENATE?

peter_turner — Mon, 22 Mar 2010 09:35:17 GMT

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.

How do I use NONCONCATENATE?

alan_grn — Mon, 22 Mar 2010 09:42:15 GMT

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.