exploding BOMs - join tables?

[#1]

Hi guys,

I just started working with Qlik Sense and I'm trying to find out how I can do with the following data:

Table 1:

parent_item_id

purchase_item_id

Table 2:

item_id

item_description

I need a table with description and all other information (table 2) for both fields on my table 1.

Is the best option a Link Table? How can I do it in this case?

Desired table:

parent_item_id

parent_item_id_description

purchase_item_id

purchase_item_id_description

All ways that I tried resulted in a synthetic key and it can't get the info that I want.

Thanks,

[JonnyPoole]

Try this... (remove the 4th field from the load, but leave it between the () after the hierarchy word:

Data:

Hierarchy(bomitem_item_id,bomitem_parent_item_id,bomitem_item_descrip,[bomitem_parent_item_description])

load

     bomitem_item_id,bomitem_parent_item_id,bomitem_item_descrip

resident Temp;

[#3]

Now it's working...thanks Jonathan.