topic Re: join tables in the script in QlikView

join tables in the script

Anonymous — Fri, 10 Jul 2015 19:10:17 GMT

Hi,

There are two resident tables in my model.

table1 has the fields A,B,C,D,E,F,G, E.

table2 has the fields A,B,C,X.

I want to join them in the script.

The condition is like that: if values in the fields A,B,C coincide, then add value of the field X to a particular row in resident table1.

Am I right that the join function is needed? How can I apply it?

Thank you in advance,

Larisa

maxgro — Fri, 10 Jul 2015 19:22:51 GMT

inner join (table1)

load *

resident table2;

drop table2;

but your 2 tables are already associated, do you really need to join?

Anonymous — Fri, 10 Jul 2015 20:44:47 GMT

I read that a multiple association between tables (via 3 common fields) in not good.

Am I right that the best way is to create an integrated key field and not to join the tables?

load

A & ' | ' & B & ' | ' & C & ' | ' & D as Key

...

Anonymous — Fri, 10 Jul 2015 20:55:50 GMT

If you join, there is no problem - all common fields will be compared.

If you want to keep the tables separate, you better create key field, for example

A&B&C as Key

in both tables

But, you have to drop the A, B, and C from at least one of the tables to avoid synthetic keys.

Anonymous — Fri, 10 Jul 2015 21:29:06 GMT

I see. Thank you!