This content has been marked as final. Show 4 replies
I have no idea why I get a table like so:
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:
Mapping Load *Inline
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