topic Re: How to replace the dash in the table by NA? in App Development

How to replace the dash in the table by NA?

userpd_2021 — Thu, 17 Mar 2022 10:53:48 GMT

Hi Team ,

I want to replace the dash value with NA and the Blank as NA .

I tried using the expression in the script.

if(IsNUll(NAME) = -1 or NAME='blank', 'NA', NAME)

If(isnull(NAME) or NAME ='blank','NA',NAME) AS NAME

I am not able to get the correct output. Also when through the community questions but this not work for me.

Re: How to replace the dash in the table by NA?

Or — Thu, 17 Mar 2022 11:07:13 GMT

If these values are missing - that is, there are no values for the intersection in your table - you won't be able to replace them with anything else directly. Some extensions will allow you to set a default null symbol that is not the native-default dash, if that's a direction you want to take.

If the values aren't missing intersections, but actual field results, you can use e.g. if(isnull(NAME),'NA',name), as you described above, so I'm guessing these are actually missing values rather than a row with a field that is null.

Re: How to replace the dash in the table by NA?

Iswarya_ — Thu, 17 Mar 2022 11:18:50 GMT

Hi,

Try like this

IF (LEN(TRIM(NAME) )= 0, 'NA' , NAME)

Re: How to replace the dash in the table by NA?

chris_djih — Fri, 18 Mar 2022 11:54:36 GMT

Try:
NullAsValue Yourtable;
NullValue = 'NA';

Before you Load this table