Discussion Board for collaboration on QlikView Scripting.
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";
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