topic conditionnal join in QlikView

conditionnal join

Thu, 16 Feb 2012 20:45:25 GMT

Hi experts,

I would like do a conditionnal join.

Table A (ID1,F1,...)

Table B (ID2,ID3,...)

if F1 =1 then link On ID1=ID2 else ID1=ID3.

Do you know if it's possible?

I have 2 fact in 1 table link on the same dimension but not on the same dimension granularity .

Eva

conditionnal join

deepakk — Thu, 16 Feb 2012 21:41:56 GMT

hi,

Try this method,

Load * , ID3, ID2 from FACT1;

Load *, ID1 as ID2 from Fact2 where F1= 1;

In the above case the ID1 of Fact2 table where F1=1 will get linked to the ID2 of Fact1 table.

Load *, ID1 as ID3 from Fact2 where F1<> 1;

In the above case the ID1 of Fact2 table where F1<> 1 will get linked to the ID3 of Fact1 table.

The above reult will create three tables.You can use the join fucntion to join these tables and make it one table

Deepak

conditionnal join

CELAMBARASAN — Fri, 17 Feb 2012 02:29:22 GMT

Hi,

Try with this approach.

TableA:

Load ID1,F1 From Datasource where F1=1;

TableB:

Load ID1,F1 From Datasource where F1<>1;

Left Join(TableA)

Load

ID2 as ID1,

ID2,

ID3

..From..

Left Join(TableB)

ID3 as ID1,

ID2,

ID3

..From..

Hope it Helps

Celambarasan

Re: conditionnal join

Fri, 17 Feb 2012 18:19:05 GMT

Hi,

Thanks for you help maybe my question is not very clear, so I build an example below .

for the first solution : the issue it's the join between Fact1 and others table is on ID2 AND DI3. but I need ID2 OR ID3.

the second doesn't works neither :'(

Another way to say that it's if ID3 exists link with it. If not link with ID2

I build a field D1 with tihs formula: if (F1 ='run' ,ID3, ID2 )