11 Replies Latest reply: Dec 14, 2015 1:07 PM by Laercio do Vale RSS

    exploding BOMs - join tables?

    Laercio do Vale

      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,