Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,I want to map and replace a empty field value with a specific value using applymap().
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