topic Re: NoConcatenate with example in QlikView

NoConcatenate with example

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi Qlikview experts,

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

thanks in advance.

Re: NoConcatenate with example

alexandros17 — Tue, 14 Jul 2015 14:48:21 GMT

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

Re: NoConcatenate with example

Kushal_Chawda — Tue, 14 Jul 2015 14:57:28 GMT

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/

Re: NoConcatenate with example

jagan — Wed, 15 Jul 2015 03:31:55 GMT

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.