3 Replies Latest reply: Jun 26, 2015 8:33 AM by Colin Albert RSS

    Joining tables with dublicate values

    Андрей Шепель

      Good day!

       

      In my model i load two tables:

       

      Main:

      LOAD

      *

      FROM

      Example.xlsx

      (ooxml, embedded labels, table is Sheet1)

      ;

       

      Left join(Main)

      load

      *

      from

      Example.xlsx

      (ooxml, embedded labels, table is Sheet2)

      ;

       

      But in second table there more than one value for every (or some) Nomenclature_Id.

      I need to join  value from first rows for field Name;

       

      Necessary result:

       

      Nomenclature_IdName
      211Name1
      234Name1
      454Name1
      456Name1