8 Replies Latest reply: Nov 21, 2017 11:38 AM by Bill Markham RSS

    Any suggestions on how to applymap correctly ?

    Layla Mar

      Hello,

       

      Here is my load script :

       

      LOAD

       

      Country

       

      FROM [lib://AttachedFiles/Updated data files.xlsx]

      (ooxml, embedded labels, table is [Table 1]);

       

      LOAD

          CountryC,

          RegionTS

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

      (ooxml, embedded labels, table is [Table2]);

       

      Need to show Country from Table1 as RegionTS in Table2

       

      Here is my applymap script:

       

      MappingTable:

      Mapping

      LOAD CountryC,

          Region

      FROM

      [lib://AttachedFiles/REGIONS.xlsx]

      (ooxml, embedded labels, table is [Table2]);

       

      Fact:

      LOAD Country,

      ApplyMap('MappingTable', RegionTS, 'N/A') as Region

      FROM

      [lib://AttachedFiles/Updated data files.xlsx]

      (ooxml, embedded labels, table is [Table 1]);

       

      Script is not working. Any suggestions ?