I'm joining two tables in ArcGIS Insights (ArcGIS Online) and I know both tables will have orphans after the join. For my analysis, these orphans need to have the column I'm measuring on converted from Null to zero.
Once I create the joined table, I'm viewing the table and clicking +Field button, with the intent to create a new field that follows this logic:
IF [measure_field] is null, THEN Value=0, ELSE Value=[measure_field]
In the Insights calculate field window, I couldn't find a way to check if a field's value is null. Is this possible? Or is there a better way to cleanup nulls during the join?
Have you tried: IF ([measure_field]="", 0, [measure_field]) ?
At the moment there is no ISNULL function.
I hope that helps.