Data Cleansing for dynamic field inputs

[nathanedwards]

I know the normal "Data Cleansing" tool has limitations where you have to make sure to reselect all fields when your input has dynamic field names.

What is the formula to use in the "Multi-Field Formula" tool to mimic the "Replace Nulls" section of the "Data Cleansing" tool?

[binuacs · Accepted solution]

@nathanedwards you can write to the formula like below

[apathetichell]

@nathanedwards - you should use @binuacs suggestion. Data Cleansing is a bad tool when used at scale. It's a memory eater which can be hugely problematic in certain situations. Multi-Field Formula is dope.