Need logic for join for dimension drill down based on other table

[alina_qlik]

Hello Experts ,

Even though i am new to Qlik but , i have learnt a lot from community about join , yet somehow not sure about below problem statement . Sorry in advance , if i have asked something "no brainier" . 

I have two tables , using which i need a resulting table which depicts dimension drill down .

Table 1 :

Client	ProductType	INCOME	Region
Merck	Cash	200	US
Merck	CashX	100	US
Merck	AUS Val	100	US
Merck	Local Draws	25	US
Merck	Bonds	75	US
Merck	Share	50	US
Merck	Debentures	50	US
INV	Cash	300	GB
INV	CashX	120	GB
INV	AUS Val	180	GB
INV	Local Draws	60	GB
INV	Bonds	60	GB
INV	Share	180	GB

Table 2

Product Levl 1	Product Levl 2	3Product Levl 1
Cash	CashX	Local Draws
Cash	CashX	Bonds
Cash	AUS Val	Share
Cash	AUS Val	Debentures

Resulting Table 

Corp	Region	Product	Product Levl 2	3Product Levl 1	INCOME
Merck	US	Cash	CashX	Local Draws	25
Merck	US	Cash	CashX	Bonds	75
Merck	US	Cash	AUS Val	Share	50
Merck	US	Cash	AUS Val	Debentures	50
INV	GB	Cash	CashX	Local Draws	60
INV	GB	Cash	CashX	Bonds	60
INV	GB	Cash	AUS Val	Share	180
INV	GB	Cash	AUS Val	Debentures	-

Thank You Qlikxperts ...

Attached file for reference .

[StarinieriG]

Hi,

this script should work 

LOAD Client,
ProductType,
Region
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 1]);

Right Join
LOAD [Product Levl 1]as ProductType,
[Product Levl 2],
[3Product Levl 1]
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 2]);

Left Join
LOAD Client,
ProductType as [3Product Levl 1],
INCOME,
Region
FROM
GRANULARITY.xlsx
(ooxml, embedded labels, table is [Table 1]);

[alina_qlik]

Thank You StarinieriG .  Can similar join logic be used for second table where we have granularity like 

Product level 1 , 2, 3 , 4 , 5 .. 

[StarinieriG]

I think that it should work