Formula for nulls

[calvincarr29]

Is there a formula I can utilize to get rid of nulls in my entire data set? Data cleansing isn't working.

[PanPP]

Hi @calvincarr29 

You can use the formula below. Are you manually inputting in the [Null] values? If you are, you can just leave them blank and it will show up as null in the result window.

If [ColumnName] = "[Null]" then "" else [ColumnName] endif

You can leverage the Multi Field formula tool if you want to apply this to several columns.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[calvincarr29]

@PanPP  is there a way to do all of the columns in one formula or do I have to do them for each individual column? If not I have to do it for 50 states. 

[PanPP · Accepted solution]

You will need to leverage the Multi-Field formula as shown below.

[calvincarr29]

@PanPP Thank you so much