Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Dhivaharan
Partner - Contributor II
Partner - Contributor II

Apply map()

Hi,I want to map and replace a empty field value with a specific value using applymap().

Labels (2)
1 Reply
vchuprina
Specialist
Specialist

Hi,

You can create mapping table by autogenerate function 

EmptyValueMap:
MAPPING LOAD
'' as Key,

'Your value' as Value
AUTOGENERATE 1 ;

then you can use it in applymap function

applymap(‘EmptyValueMap’, Field) As Field

Regargs,

Vitalii

 

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").