Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Arjunarao
Not applicable

NoConcatenate with example

Hi Qlikview experts,

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

thanks in advance.

1 Solution

Accepted Solutions
Highlighted
jagan
Not applicable

Re: NoConcatenate with example

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.

3 Replies
alexandros17
Not applicable

Re: NoConcatenate with example

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

kush141087
Not applicable

Re: NoConcatenate with example

Highlighted
jagan
Not applicable

Re: NoConcatenate with example

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.