6 Replies Latest reply: Sep 4, 2014 4:16 AM by Alessandro Saccone RSS

    Remove data from the loaded field

    Andrzej Bejmart

      Hi guys,

       

      let say I have list of the Delivery Companies in the database. With some of them are not working any more or changed the name, so I want to remove them or rename. So renaming works fine when I use ApplyMap but it fail when I wanted it to remove them as it just replace data with blank line.

       

      DLMap:

      MAPPING LOAD * INLINE [

          DL, newDL

          Sony,

          Samsung,

          JVC,JVC Inc.

          ];

       

      then

       

      LOAD

      ApplyMap('DLMap', DL_DESC) as DL_DESC

      FROM

      xxxxx

       

      This will rename JVC to JVC Inc., but Sony and Samsung are replaced with blank data.

      Is there is any other way to remove them from being loaded?

       

      Thank you