4 Replies Latest reply: Feb 18, 2014 3:16 PM by Byron Van Wyk RSS

    mapping /applymap

    Karolina Papaj

      Hi All,

       

      I have a problem with mappig/applymap. Hope somebody can help me.

       

       

      MapNames:

      Mapping

      Load Distinct

      [Table1.ID],[Table1.ID Name]

      resident [Table1];

       

      I have tried to achieve it in two ways:
      #1

      [Temp Table2]:

      NoConcatenate

      Load Distinct

          Key                                        AS Key1,

          [Table2.CHILD ID]           AS [Table2.CHILD ID1],

          [Table2.CHILD ID]           AS [Table2.CHILD Name1],

      Resident [Table2]

      Group by Key;   

       

      map [Table2.CHILD Name1] using MapNames;

       

      #2

      [Temp Table2]:

      NoConcatenate

      Load Distinct

          Key                                        AS Key1,

          [Table2.CHILD ID]           AS [Table2.CHILD ID1],

           ApplyMap('MapNames',[Table2.CHILD ID],'[None]') AS [Table2.CHILD Name1],

      Resident [Table2]

      Group by Key;