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?
