Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

IS NULL Mapping Load

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,

1 Reply
rupe
Not applicable

Re: IS NULL Mapping Load

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