NoConcatenate with example

[qlikviewwizard]

Hi Qlikview experts,

Where we can use NoConcatenate in qlikview . please give an example.

thanks in advance.

[alexandros17]

TTT:

Load A,B,C Resident Tab1;

ZZZ:

noconcatenate

Load * resident TTT;

left join

Load * resident Table999;

Drop table TTT;

Without noconcatenate the drop would delete even the table ZZZ

[Kushal_Chawda]

Please see the below links

http://www.learnallbi.com/concatenate-and-noconcatenate-in-qlikview-part-1/

http://www.learnallbi.com/concatenate-and-noconcatenate-in-qlikview-part-2/

[jagan · Accepted solution]

Hi,

Generally Qlikview will Autoconcatenate if the columns in both the tables are same.  To avoid this we need to Noconcatenate option.

Let us try with an example

Without NoConcatenate:

Data:

LOAD

*

INLINE [

Value1, Value2

A, 100

b, 200];

Data1:

LOAD

*

INLINE [

Value1, Value2

A, 100

b, 200];

Both tables Data and Data1 are merged into a single table Data.

With NoConcatenate:

Data:

LOAD

*

INLINE [

Value1, Value2

A, 100

b, 200];

Data1:

NoConcatenate

LOAD

*

INLINE [

Value1, Value2

A, 100

b, 200];

Now two tables will be created.

Hope this helps you in understanding the concepts.

Regards,

Jagan.