Can anyone tell me the use of Concatenate and No Concatenate with a basic example ??

[nikhilgarg]

HEy,

Can anyone tell me the use of Concatenate and No Concatenate with a basic example ??

Thanks

[#2]

Hi Nikhil,

This will surely help,

Concatenate and NoConcatenate in QlikView – Part 2 | Learn QlikView

Thanks

Sudhanshu shrivas

[its_anandrjs · Accepted solution]

Hi,

If you use Concatenate in between tables means two table concatenate to each other and reverse is noconcatenate

Ex:-

1. In Noconcatenate you get synthetic table also

LOAD * Inline  [

ColA,ColB

1,a

2,b

3,c ];

NoConcatenate

LOAD * Inline  [

ColA,ColB

1,d

2,e ];

2. In concatenate you get single table

LOAD * Inline  [

ColA,ColB

1,a

2,b

3,c ];

Concatenate

LOAD * Inline  [

ColA,ColB

1,d

2,e ];

Regards

Anand

[prma7799]

Hi,

Concatenate:Append row or column into single table

NoConcatenate:keep table as it is without append any rows.

Try this... you will get idea.

Table11:

LOAD * INLINE

[

A, B, C

1, 1, 1

2, 2, 2

3, 3, 3

];

Concatenate

Table22:

LOAD * INLINE

[

B, C, D

2, 2, 2

3, 3, 3

5, 5, 5

];

Table11:

LOAD * INLINE

[

A, B, C

1, 1, 1

2, 2, 2

3, 3, 3

];

noConcatenate

Table22:

LOAD * INLINE

[

B, C, D

2, 2, 2

3, 3, 3

5, 5, 5

];

Thanks,

Prashant

[advait_thakur]

Dear Nikhil,

  The No Concatenate prefix forces two tables with identical field sets to be treated as two separate tables in QlikView.

On the other hand, If all fields are common between two tables then QlikView will automatically concatenate it.

You may also explicitly mention the command Concatenate between two tables. In this case QlikView will treat it as on single table.

Concatenate Ex: Load Table 1 A, B, C ;

                          Load Table 2 A, B, C; (QV will auto concatenate as the fields are same)

NoConcatenate  Ex: Load Table 1 A, B, C ;

                               NoConcatenate 

                               Load Table 2 A, B, C;  (QV will not auto concatenate as NoConcatenate  function is used)

Regards

Advait

[#6]

when the tables are not same(fields) and u want combine the table then u can go for concatenation

when tables are same(fields) then qlikview automatically do concatenation to avoid this we go for noconcatenation

u can refer above anand examples