topic IS NULL Mapping Load in QlikView

IS NULL Mapping Load

Fri, 20 Mar 2015 10:15:19 GMT

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

Roop — Fri, 20 Mar 2015 10:22:38 GMT

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