topic Re: ON Condition in Join in QlikView

ON Condition in Join

Anonymous — Tue, 08 Sep 2015 10:43:20 GMT

Hi,

I have 2 tables which I want to join together,

by 2 conditions:

1. Both have the same ID

2. Attribute "Duration" in table 1 is larger then attribute "Day" in table 2

in SQL I would do:

select *

from table1

JOIN table2

ON table1.duration>table2.day AND table1.id=table2.id

How do I do it in Qlikview?

*note: I would like to aggregate columns after it

Re: ON Condition in Join

gautik92 — Tue, 08 Sep 2015 10:49:11 GMT

use where condition

Re: ON Condition in Join

alexandros17 — Tue, 08 Sep 2015 10:52:35 GMT

I would not use the duration and date information to link the tables, just:

load id,f1,f2,f3 resident table1;

join

load id,f4,f5,f6 resident table2;

Re: ON Condition in Join

tresB — Tue, 08 Sep 2015 10:55:11 GMT

Try like:

Temp:

Load * From Table1;

Join

Load * From Table2;

NoConcatenate

Final:

Load * resident Temp where duration>day;

Drop table Temp ;

Assuming id is only common field.

Re: ON Condition in Join

sasiparupudi1 — Tue, 08 Sep 2015 11:00:47 GMT

table1:

sql select id,duration from sometable;

noconcatenate

table2:

sql select id,dayfrom someothertable;

noconcatenate

final:

load id,duration resident table1;

join

load id,day resident table2;

where duration>day

hth

Sasi

Re: ON Condition in Join

Anonymous — Tue, 08 Sep 2015 14:09:04 GMT

NoConcatenate!!