Get rid of Nulls after ApplyMap?

[#1]

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:

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;

[#2]

Hi, According to script the Applmap won't return any value. To verify that goto table viewer and place the cursor on the "Cookied" field. I believe the null value is coming from the fields used in expression.

Can you please post sample qvw to review why chart object return the null value.

[effinty2112 · Accepted solution]

Hi Sean,

Does the field 'Cookied' appear in another table apart from finaltable? Maybe a table intended to be temporary that hasn't been dropped?

Cheers

[manojkulkarni]

what all values present in Audience_Category ? how is your dimension & expression linked ?

[#5]

Fantastic, thank you!

Yes, I forgot to drop the previous working table before the applymap, hence the nulls.