Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

NoConcatenate with example

Hi Qlikview experts,

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

thanks in advance.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

jagan
Luminary Alumni
Luminary Alumni

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.