6 Replies Latest reply: Aug 17, 2018 8:23 AM by manoj kumar RSS

    Left Join

    Itamar Levi

      Hi,

       

      I would like to create a left join between two tables: ChecklistTasks and JoinCountryNew.

      The connection field is COUNTRY in the two tables.

       

      Please help me to identify what I do wrong and how to write the code correctly:

       

      [vLookup]:

      Left Join ([ChecklistTasks])

      LOAD

          COUNTRY,

          Country_Cluster,

          Region

      FROM [lib://AttachedFiles/JoinCountryNew.xlsx]

      (ooxml, embedded labels, table is Sheet1);