Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
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.
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
what all values present in Audience_Category ? how is your dimension & expression linked ?
Fantastic, thank you!
Yes, I forgot to drop the previous working table before the applymap, hence the nulls.