topic Joins with Or Condition in App Development

Joins with Or Condition

Yashwanth_ — Wed, 30 Jun 2021 03:19:28 GMT

Hi ,

I have Two tables from sql .

Table1:

select

Filed A_Table1,

Filed B_Table1,

Nar1,

Nar2,

Fieldc_Table1

from Table 1

left join

select

FieldA_table2,

FiledB_table2,

WOTRNO,

WOSWIF,

FiledC_table2

(Nar1 = WOTRNO ) or (Nar1 = WOSWIF);

My question is how to use that left join with or conditions in Qlik sense load editor .

Thanks ,

Yashwanth.

Re: Joins with Or Condition

chrismarlow — Wed, 30 Jun 2021 12:39:38 GMT

Hi,

I don't think you can do it directly.

Things I have done similar you do two left joins, then load to a new table combining the joined fields to tidy up, so;

1) Join on NAR1=WOTRNO adding WOTRNO prefix to your fields on your second

2) Join on NAR1=WOSWIF adding WOSWIF prefix to your fields on your second table

Ideally then have 'WOTRNO_FieldA_table2' and 'WOSWIF_FieldA_table2' on your first table

3) Then do a load (usually use noconcatenate) with something like this If(WOTRNO_FieldA_table2=null(),WOSWIF_FieldA_table2,WOTRNO_FieldA_table2) as FieldA_table2 for each field

4) Drop tables as needed

Cheers,

Chris.