1 Reply Latest reply: Oct 19, 2012 3:58 AM by Stefan Wühl RSS

    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

        • Re: Common values not getting highlighted in the table
          Stefan Wühl

          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?