how to replace value of specified column to null ？

[phoebe_90]

how to replace value of specified column to null ？

for example, change the value of Cost Center Code to null

Cost Center Code	Tax code
706010	J4
706140	J4
709384	J5
709381	J4
706010	J4
706002	J5

[ShankerV · Accepted solution]

Hi @phoebe_90 

Please use the formula tool.

IF [Cost Center Code] = "706010"

THEN Null()

ELSE  [Cost Center Code]

ENDIF

Many thanks

Shanker V

[phoebe_90]

what if I want to change the whole Cost Center Code column into null?

[dwstada · Accepted solution]

you would select the column in a formula tool and write "null()" as the formula which will overwrite everything in the column