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
Solved! Go to Solution.
Please make use of the Multi Field formula.
IF [_CurrentField_] = "NULL"
THEN Null()
ELSE [_CurrentField_]
ENDIF
Many thanks
Shanker V
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.
Thanks