Add a column to main table which shows information from 2 tables

[MvR]

Hi,

I try to add a column to my main table in qlick, which needs information from 2 tables merge in one column. 

Main table:

Orderdetails
Code	Description	Salesprice	Type
1	Abc	10	Item
2	def	100	Assembly
3	ghi	90	Assembly
4	jkl	20	Item
5	mno	15	Item

Information I want to add:

Item
Code	Itemgroup
1	1
4	3
5	2

&

Assembly
Code	Itemgroup
2	3
3	4

Result I try to achieve:

Orderdetails
Code	Description	Salesprice	Type	Itemgroup
1	Abc	10	Item	1
2	def	100	Assembly	3
3	ghi	90	Assembly	4
4	jkl	20	Item	3
5	mno	15	Item	2

Does anyone have any idea if this is feasible and how?