topic Re: multiple join in QlikView

multiple join

entsh — Tue, 31 May 2022 18:08:39 GMT

hello

would you please help me:

table1

table2:

I want to compare table 1 and table 2 (column date with columns date1,date2,date3) and add & fill num1,num2,num3( red columns)

result:

what should i write in edit script?

thanks

stevejoyce — Tue, 31 May 2022 21:08:04 GMT

assuming table 1 and table 2 loaded already.

left join (table2)

load

date as date1

, num as num1

resident table1;

left join (table2)

load

date as date2

, num as num2

resident table table1;

left join (table2)

load

date as date3

, num as num3

resident table1;

drop table table1;

MayilVahanan — Wed, 01 Jun 2022 02:02:41 GMT

Try like below

MapNum:

Mapping Load date, num from table1;

Load date1, applymap('MapNum', date1, 0) as num1,

date2, applymap('MapNum', date2, 0) as num2,

date3, applymap('MapNum', date3, 0) as num3

from table2;

Hope it helps