Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
svinnakota
Creator
Creator

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
Partner - Champion
Partner - Champion

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
Partner - Contributor III
Partner - Contributor III

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