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

    Load table using data from already loaded table

      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?