How to change string to null() value - Qlik Community

AMAN1 · ‎2021-09-27

I have many columns as nan as value but I want to change that nan to null() using mapping ....how to do it?

micheledenardi · ‎2021-09-30

This is the solution using mapping table:

MapNan:
Mapping
Load 
'nan' as ValueToFind,
null() as ValueToReplace
Autogenerate(1);

YourTable:
Load *,
ApplyMap('MapNan',YourField) as NewField
From ....;

Consider also to use Replace() function.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

PrashantSangle · ‎2021-09-30

check this thread

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ValueHandlingVa...

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂