Insights - Calculate field to zero after full outer join

346
1
02-13-2020 08:56 AM
AndrewRudin1
Occasional Contributor

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?

0 Kudos
1 Reply
AkshayHarshe
Esri Contributor

Hi, 

Have you tried: IF ([measure_field]="", 0, [measure_field]) ?

At the moment there is no ISNULL function. 

I hope that helps.

Thanks,

Akshay

Thanks,
Akshay Harshe
Product Engineer at Esri
ArcGIS Insights
0 Kudos