topic Re: handling null values in dimension and replace by value other . in App Development

handling null values in dimension and replace by value other .

meenakshi_m — Tue, 02 Mar 2021 16:26:46 GMT

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

Re: handling null values in dimension and replace by value other .

Ksrinivasan — Tue, 02 Mar 2021 18:45:25 GMT

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

Re: handling null values in dimension and replace by value other .

meenakshi_m — Tue, 02 Mar 2021 18:57:31 GMT

Thanks yes this is working.