handling null values in dimension and replace by value other .

[meenakshi_m]

Hi ,

I have 2 tables one is static data and other date with details.Both are connected with common field. when i try to pull resident i get null value in resident which i want to name it as  other.Qvd file attached. appreciate help

[Ksrinivasan · Accepted solution]

hi,

Use Applymap function with Mapping load,

TAB1:

Mapping Load

Student,

Resident

from:

Tab2:

Load

Student,

Applymap('Tab1',Student,'Others') as Resident,

mark1,

Mark2

From

ksrini

[meenakshi_m]

Thanks yes this is working.