How to replace NULL with null cells?

[ShantanuDagar]

Hello,

The question looks weird but isn't lol.

I need to replace all the cells spread across different columns with NULL spelt out to actual null cells ([null]).

Thanks

[ShankerV · Accepted solution]

Hi @ShantanuDagar 

Please make use of the Multi Field formula.

IF [_CurrentField_] = "NULL"
THEN Null()
ELSE [_CurrentField_]
ENDIF

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @ShantanuDagar, if you drag a Multi-Field Formula tool into your workflow and select all of the fields you want to apply this to, you can then just put the following in your expression editor which will replace all instances of the word 'NULL' with an actual null value:

IF [_CurrentField_] = 'NULL' THEN NULL() ELSE [_CurrentField_] ENDIF

Example attached.

[ShantanuDagar]

Thanks