topic Problem joining tables in QlikView

Problem joining tables

Wed, 03 Nov 2010 12:23:42 GMT

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;

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;

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

sparur — Wed, 03 Nov 2010 12:38:20 GMT

I think you should use CONCATENATE statement:

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

Wed, 03 Nov 2010 12:43:01 GMT

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 ....

Problem joining tables

Wed, 03 Nov 2010 12:50:29 GMT

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 🙂