Hi
I am very new to qliksense and scripting in qlik seems to be very hard and intersting at the beginning. I need help in joining multiple tables with multiple common fields.
Please help me.
exist_in_flag:
mapping Load
sbscrnum,
1 as exist_in_table
FROM [lib://AttachedFiles/table2.xlsx]
(ooxml, embedded labels, table is Sheet1);
T1:
LOAD
sbscrnum,
companyid,
invno,
addr,
city,
country,
Moneyy,
ApplyMap('exist_in_flag',sbscrnum,0) as exist_in_flag
FROM [lib://AttachedFiles/table1.xlsx]
(ooxml, embedded labels, table is Sheet1);
T2:
NoConcatenate
LOAD
sbscrnum,
companyid,
invoiceno as invno,
Moneyy
FROM [lib://AttachedFiles/table2.xlsx]
(ooxml, embedded labels, table is Sheet1);
LEFT JOIN(T2)
LOAD sbscrnum,Moneyy,
addr,city,country
Resident T1
where exist_in_flag = 1 ;
Concatenate
LOAD sbscrnum,invno,companyid,addr,city,country,Moneyy
Resident T1
where exist_in_flag = 0;
T3:
NoConcatenate
LOAD *
Resident T2;
JOIN(T2)
LOAD
sbscrnum,
speedname,
Type,
subscriptionaddr as addr,
subcity as city,
subcountry as country
FROM [lib://AttachedFiles/table3.xlsx]
(ooxml, embedded labels, table is Sheet1);
I am getting output like this

But I need something like this,

Data sample:

I tried joins and concatenate. The main idea is I need addr,city and country fields to be matched. As I am very new to this. Please guide me how to proceed. Thanks a lot in advance