Concatenate Issue

[Anonymous]

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

[MK_QSL]

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..

[MarcoWedel]

Hi,

maybe this helps:

Understanding Join, Keep and Concatenate

regards

Marco