Replace Null in Data

[prashant007]

Hi,

I was trying to remove Null values from a dataset. What I am trying is to replace in same column rather than creating new column with formula tool or multirow tool. Any suggestion in this regard will be helpful.

[IraWatt]

Hi @prashant007,

What do you want to replace the NULLS with. The data cleansing tool has a lot of simple options for replacing nulls:

Or you could use a formula for a more specific replacements 

[AmalinaH]

Hi @prashant007, you can use a formula tool to replace a value in an existing column, rather than create a new column. If that's what you're looking for?

If you could share a sample data set with the input and expected output we could try and put a few tools together to solve this.

[Jay-RDC]

data cleansing tool should work if you're merely trying to remove NULL values. If the values you're trying to get to replace the Null values are from the same file you can also use formula tool "if isNULL([field]) then [filed2] else [field] endif". If the values are coming from a different row  then it would be best to use a multi row formula tool. Make sure to sort your data and use

"IF isNULL([Field])Then [Row-1:Field]
else [Field]
ENDIF" 

Hope this helps!