4 Replies Latest reply: Jul 4, 2013 3:11 AM by michael.kwok RSS

    ApplyMap(), looking for advice?

      Hi All

       

      Could anyone give me some hints related to below issue:

       

      [Mapping table A]:

      mapping LOAD * INLINE [

          ID, Name

          A1, Apple

          B2, Boy

          C3, Cat

      ];

       

      [Table1]:

      LOAD CustID,

      ApplyMap('[Mapping table A]', CustID, 'Unknown') as [Full Name],

           Values

      FROM

      MappingExercise.xls

      (biff, embedded labels, table is [Sheet1$]);

       

      My excel table structure is:

      CustIDValues
      A1100
      B2200
      C3101

       

       

      i would like to display full name, however, after reload the scripts, i got the result as below:

      CustIDFull NameValues
      A1 100
      B2 200
      C3 101

       

       

      Pls advice. Thanks