How to replace null value only in one column

[#1]

Hi,

I have two columns like below

Employee	Department
101	NULL
201	10
NULL	10
NULL	30

I have to replace Department NULL value = N/A but Employee NULL Value should remain same.

IN Straight table under presentation tab when I am using Null Symbol= N/A it is showing in Employee also which is not my case. I need N/A only in Department.

Could anyone help me how to do this please.

Thanks.

[MayilVahanan]

Hi

Try like this

Load

If(Len(Trim(Department)) = 0, 'N/A', Department) As Department

..

From TableName;

Then use Department in charts.

Hope that helps

[tresesco]

Try expression like:

If(IsNull(Department), 'N/A', Department)

[CELAMBARASAN]

Its a global property it applies to all expression.

You should change the value in script or

in expression using if(IsNull(FieldName), 'NA', FieldName)

[saumyashah90]

if Table1 is already loaded,

then

Table2:

NoConcatenate

Load

Employee,

If(Len(Trim(Department))=0,'N/A',Department) as Department
residentTable;

You can get it.

[#6]

Thanks and if I want to replace Department 10='Sales' and Department NULL= 'Accounts'

will the below statement works?

If(Department= 10, 'Sales',IF(ISNULL(Department), 'Accounts')) as Dept

[tresesco · Accepted solution]

A little bit of tweak:

If(Department= 10, 'Sales',IF(ISNULL(Department), 'Accounts', Department)) as Dept

Include the Department in else part, otherwise rest departments would be ignored.

[#8]

Thanks and it's working.

[#9]

Thanks Saumya and it's helpful