topic Re: Connect two tables with 2 keys in QlikView

Connect two tables with 2 keys

Anonymous — Tue, 26 May 2015 17:52:27 GMT

Good day!

i have one table with fileds:

Sales:

Company

Product_Id

Second table

Product classifier:

Company

Product_Id

Product_name

In result it make syn key.

How to connect these two tables w/o syn key ?

Thx.

Re: Connect two tables with 2 keys

sunny_talwar — Tue, 26 May 2015 17:57:08 GMT

You can try it this way, though there might be other ways. You need to give more details to give you a solution which will suit you the best.

QUALIFY *;

UNQUALIFY Join;

Sales:

LOAD Company,

Product_Id,

Company&Product_Id as Join

FROM yourSource1;

[Product Classifier]:

LOAD Company,

Product_Id,

Product_name,

Company&Product_Id as Join

FROM yourSource2;

UNQUALIFY *;

HTH

Best,

Sunny

Re: Connect two tables with 2 keys

Tue, 26 May 2015 18:05:03 GMT

I think Product_Name is high level data granularity dimension, Just use ApplyMap or Left join the table.

Re: Connect two tables with 2 keys

maxgro — Tue, 26 May 2015 19:04:25 GMT

1) there is no need to remove the syn key

2) but if you want to remove

Sales:

load Company & '-' & Product_Id as Key inline [

Company, Product_Id

a,1

b,2

];

[Product classifier]:

load *, Company & '-' & Product_Id as Key inline [

Company, Product_Id, Product_name

a,1,product a

b,2, product b

c,1, product c

];

3) another remove syn key

Sales:

load AutoNumber(Company & '-' & Product_Id) as Key inline [

Company, Product_Id

a,1

b,2

];

[Product classifier]:

load *, AutoNumber(Company & '-' & Product_Id) as Key inline [

Company, Product_Id, Product_name

a,1,product a

b,2, product b

c,1, product c

];

Re: Connect two tables with 2 keys

Anonymous — Wed, 27 May 2015 06:44:20 GMT

Many thanks)

Re: Connect two tables with 2 keys

Anonymous — Wed, 27 May 2015 06:44:37 GMT

Thanks for advice!

Re: Connect two tables with 2 keys

Anonymous — Wed, 27 May 2015 06:44:52 GMT

Thanks