Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

1 Solution

Accepted Solutions
Not applicable

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 Smiley Happy

3 Replies
sparur
Valued Contributor II

Problem joining tables

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

Not applicable

Problem joining tables

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

Not applicable

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 Smiley Happy

Community Browser