topic Re: join based on 2 columns in same table in a script in QlikView

join based on 2 columns in same table in a script

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

Hi,

I have a table and I want to add column to env=A_A only in case AGREEMENT_A=AGREEMNT_B.

This is not working:

left join(Fact1)
load distinct ticket, approval_project_url as APPROVAL_PROJECT
RESIDENT Fact1

where AGREEMENT_A=AGREEMNT_B;

can you please help.

Re: join based on 2 columns in same table in a script

vinieme12 — Mon, 15 Jan 2018 14:08:56 GMT

if both fields are in the same table then an IF() statement would suffice

LOAD

ticket,

AGREEMENT_A,

AGREEMNT_B,

if(AGREEMENT_A=AGREEMNT_B.,'A_A') as env,

FROM XXXXx;

Re: join based on 2 columns in same table in a script

juraj_misina — Mon, 15 Jan 2018 14:29:43 GMT

Hi Anat,

Qlik makes joins based on common field names, so you do not need to use any where condition, the important thing are names of those fields. So if you for any reason need to make a join a AGREEMENT_A=AGREEMENT_B you should do

tbl1:

LOAD

env,

ticke,

AGREEMENT_A

from source;

left join (tbl1)

LOAD

env,

ticke,

AGREEMENT_B as AGREEMENT_A

from source;

Hope this helps

Juraj