Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Common values not getting highlighted in the table

Hi All,

I have a query regarding joining of common items. I have 3 tables, namely, Table A, Table B & Table C. There are some items in A & B which should be included in C also under the same heading. These 3 tables are in different excel sheets which i am loading into the script.

Table A
Table B
Table C
x1y1z1
x2y2z2
x3y3z3
x4y4x1
x5y5y2
x6y6x4
x7y7y5

When i am loading the data, all the common values of X series and Y series, which are also there in Table C are showing under their original table names. I tried to use a composite key also, by giving them an unique name and then tried to map them but it did not work.

Kindly help on the above issue.

Thanks

Anirban

1 Reply
MVP
MVP

Re: Common values not getting highlighted in the table

So if you have loaded the three Excel tables, you have three tables in QV, not linked to each other, because they don't share a common field name, right?

 

If your fields are not in the same table, it is probably best to separate these tables, looking at your sample above I might think you have one table with three fields, one record has entries in fields called 'Table A', 'Table B', 'Table C' (or in other words, value x1 in field Table A in in the same record as value y1 in field 'Table B'.

Or maybe this is what you want to show?

I haven't fully understood which values of your table A and B you want to add to Table C, or how your final data model should look like. Could you post your expected outcome?

Community Browser