Problem joining tables

[#1]

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

[sparur]

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$]);

[#3]

There are two more tables named as B & C which have the same column headings hence have used the Qualify statements so that the columns read as ATotal, BTotal etc

Can't remove the Qualify statements ....

[#4 · Accepted solution]

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 🙂