4 Replies Latest reply: Dec 8, 2015 9:37 PM by sean chua RSS

    Get rid of Nulls after ApplyMap?

      I have no idea why I get a table like so:

      2nbNmWK.png

      the '-' denoting null, when I have already specified a default value under applymap?

       

      I cannot use 'suppress null values' because it affects my other calculations.

       

      Here is part of my load script:

       

      MapCookieToAudCategory:

      Mapping Load *Inline

      [

      Category,Cookie

      None,Non-Cookied

      Buyers,Cookied Buyers

      ];

       

      finaltable:

      Load

        *,

        ApplyMap('MapColorToContinent',[Feeder_Continent],0) as Feeder_Color,

        ApplyMap('MapColorToContinent',[Destination_Continent],0) as Destination_Color,

        ApplyMap('MapColorToAudCategory',[Audience_Category],0) as Audience_Color,

        ApplyMap('MapCookieToAudCategory',[Audience_Category],'Cookied Non-Buyers') as Cookied

      Resident bqsem;