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:
&
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?