1 Reply Latest reply: Mar 20, 2015 6:22 AM by Rupert Cavendish RSS

    IS NULL Mapping Load

    Wande Sulu

      Hi all,


      Please I will like to check whether this script is correct:

       

       

       

      Map_Sales:
      MAPPING
      LOAD

      IF
      (IsNUll("SalesID"), '1001', "SalesID") AS "SalesID"
      ,
      IF
      (
      IsNUll("SalesName"), 'Not Known', "SalesName") AS [SalesType]
      ;
      SQL
      SELECT *
      FROM "Systems"."Sales";

       

       

      Regards,

        • Re: IS NULL Mapping Load
          Rupert Cavendish

          You have done the Mapping Load that creates the map - Then you need to perform the ApplyMap('Map_Sales' .....

           

          Otherwise it is fine - but you may wish to group the SalesID and SalesName to ensure there are no duplicates - it would still work but be a bit more efficient