3 Replies Latest reply: Nov 3, 2010 8:50 AM by umangu2000 RSS

    Problem joining tables

      Hi,

       

      I'm loading data from different excel files, However the resultant tables are not joined automatically and QV is creating a different table with the same details for the two tables

      My Script statement:

       

      Qualify*;

      Unqualify ID;

      Unqualify Firm;

      A:

      LOAD ID,

      Bank as Firm,

      Total,

      [F O],

      [F A],

      [NL F A],

      DBR,

      Distinct

      FROM [Base Data\ Roles.xls] (biff, embedded labels, table is [Advisor$]);

       

       

      Qualify*;

      Unqualify ID;

      Unqualify Firm;

      A:

      LOAD ID,

      Bank as Firm,

      Total,

      [F O],

      [F A],

      [NL F A],

      DBR,

      Distinct

      FROM [Base Data\ Roles New.xls] (biff, embedded labels, table is [Advisor$]);

       



      However when I run the script I get two tables in my QV named as A & A-1

       

      Could someone pls point out what am I missing here ....

       

      Thanks

        • Problem joining tables
          Anatoly Pyatygo

          I think you should use CONCATENATE statement:

          A:

          LOAD ID,

          Bank as Firm,

          Total,

          [F O],

          [F A],

          [NL F A],

          DBR,

          Distinct

          FROM [Base Data\ Roles.xls] (biff, embedded labels, table is [Advisor$]);

           

          CONCATENATE(A)


          LOAD ID,

          Bank as Firm,

          Total,

          [F O],

          [F A],

          [NL F A],

          DBR,

          Distinct

          FROM [Base Data\ Roles New.xls] (biff, embedded labels, table is [Advisor$]);

          • Problem joining tables

            Got the solution thanks Sparur .....

            Loaded both the tables without Qualify statements & then again reloaded them now with Qualify statement and dropped the previous tables :)