topic help in converting SQL OR condition in QV script joins in QlikView

help in converting SQL OR condition in QV script joins

ankitasinghal — Wed, 25 Nov 2020 16:16:04 GMT

Hi Geeks,

I have below requirement

suppose we have 4 tables A, B,C,D

and I have below SQL query i want convert this query in QV kindly help me in this.

in below SQL query i am not able to write QV logic for ((A.col2=D.col2) or (B.col2 is null)) or condition.

SQL query.

select *

from table A left join table B

on A.col1=B.col2

left join C

on A.col1=C.col1

left join D

A.col1 =D.col1

and ((A.col2=D.col2) or (B.col2 is null))

Thanks,

Ankita Singhal

tripatirao — Wed, 04 Apr 2018 09:36:51 GMT

Hi,

Try to make 4 tables in excel by taking some sample data.

Load these table into qlikview and try to join

chinnuchinni — Wed, 04 Apr 2018 09:44:25 GMT

you can easily achieve this with the preceding load.

just give the same name to the fields to join the tables.

if you need proper solution please attach the sample data and your required o/p.