7 Replies Latest reply: Feb 3, 2017 12:31 PM by Sarah Sullivan RSS

    Load table using data from already loaded table

    Prasanna Chandran

      I have these two tables loaded:

       

      Product Table:
      Product ID
      Product Code

       

      Mapping Table:

      Mapping Code (Product Code+Region Code)

      Mapping Description

       

       

      I want to load another table from an excel file:

      Product Region:

      Product ID

      Region Code

       

      1) I need to add a field to this table Product Code which needs to be derived from Product Table for the matching Product ID

      2) I need to add Mapping Description derived from Mapping Table using the concatenated key of Product Code and Region Code.

       

      Resulting Table:

      Product ID

      Region Code

      Product Code - Sourced from Product Table

      Mapping Description - Sourced from Mapping table

       

      Is there a way to do it?