Common values not getting highlighted in the table

[#1]

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
x1	y1	z1
x2	y2	z2
x3	y3	z3
x4	y4	x1
x5	y5	y2
x6	y6	x4
x7	y7	y5

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

[swuehl]

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?