topic Concatenate Issue in QlikView

Concatenate Issue

Anonymous — Sat, 06 Dec 2014 20:03:31 GMT

Hi All,

I need a clarification on this

. I am having Table A and B. Here I am trying to Concatenate these tables based on key field called ID.But after concatenate when I Qlik one field from A,it is not showing the corresponding value from table B.

Due to my data model I am trying to concatenate. Otherwise I can go with Join between the tables

-Jay

Re: Concatenate Issue

MK_QSL — Sat, 06 Dec 2014 20:10:45 GMT

Consider below

TableA:

Load * Inline

[

FieldA, FieldB, FieldC

AA1, BB1, CC1

AA2, BB2, CC2

AA3, BB3, CC3

];

Concatenate

TableB:

Load * Inline

[

FieldC, FieldD, FieldE

CC1, DD1, EE1

CC2, DD2, EE2

CC3, DD3, EE3

];

now when you click AA1 from FieldA, you will get '-' for FieldE because concatenate is actually adding the three rows of TableB to TableA.

If you want FieldE to be associated with FieldA through common field FieldC, use left join or join...

Hope this helps..

Re: Concatenate Issue

MarcoWedel — Sat, 06 Dec 2014 22:15:38 GMT

Hi,

maybe this helps:

Understanding Join, Keep and Concatenate

regards

Marco