Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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").