Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

svinnakota
Contributor

Or condition during joining 2 tables in qlik sense

Hi All,

Sql: select a,b,c from table1

left join

(select c,d,e from table2)t2

on (b>d or a=e)

How to write the above joining condition in qlik sense script.

Thanks in advance,

Santosh

2 Replies
agigliotti
Honored Contributor II

Re: Or condition during joining 2 tables in qlik sense

tab1:

sql select a,b,c from table1;

left join

sql select c,d,e from table2;


tab2:

noconcatenate

load * resident tab1 where b>d or a=e;


drop table tab1;



handry_orozco
New Contributor III

Re: Or condition during joining 2 tables in qlik sense

Hi

Try this,

Select Table1.A,

           Table1.B,

           Table1.C,

           Table2.D,

           Table2.E

From Table1

Left Join Table2

On B >D

Or  A = E

Community Browser