topic How we can create 2 left joined tables join with 3rd table? in Qlik Automate

How we can create 2 left joined tables join with 3rd table?

umerfa — Fri, 06 Jan 2023 14:51:40 GMT

I have following 3 tables with linked fields

Details_Sales table

Customers table

The above 2 tables are linked with [Customer code] field

I have following 3rd table

Ranpak Support table

I need to join Ranpak Support table and Details Sale table with double field link

[Ran product code] + [ran Customer group]

How I get [Customer Group] (Customers table) field in Details Sales table to make its 2 fields link key with Ranpak support table ?

paulcalvet — Sat, 07 Jan 2023 09:55:00 GMT

Hello,

You can do something like that :

Load

[Customers code]

[Product Code]

From Details_Sales

left join

Load

[Customers code]

[Customer group]

From Details_Sales

From Customers

left join

[Ran product code] as [Customer group]

[ran customer group] as [Product Code]

[ran support]

from Ranpak Support