Hello,
May I please know a way to write a formula to search for NULL in all columns(350) of the data and replace it with 0 at once.
Thanks in advance.
Solved! Go to Solution.
use a multi-field formula
IIF(IsNull([_CurrentField_]),0,[_CurrentField_])
Cheers,
Mark
Hey @timewaste! You could either use the Multi-Field Formula Tool or the Data Cleansing Tool. Hope this helps!
Thank you for posting @MarqueeCrew! This 3 year old post solved a similar issue for me!