Hi @JoeBorgione I think this is what I'm looking for. Trying to implement now and see how it performs, but struggling with my newness to arcade and getting my head around the structure.
var row1 = $feature['featureclass.Work_Centre']
var row2 = $feature['jointable.csv.WorkCentre']
for(var r in row1) {
if (r==row2) continue;
if (r!=row2);
row2;
}
Essentially in the code section of the Calculate Field tool I'm, trying to read 2 fields in a feature class joined to a table and compare the 2 fields. If values match, continue, if not, return value from the join table (row2). Any pointers on where I've gone wrong? It told me it was valid, but when I ran it, all values were calculated as Nulls instead of being left as they were or updated with new values.
LindsayRaabe_FPCWA_0-1626396028823.png
LindsayRaabe_FPCWA_1-1626396205356.png
Lindsay Raabe
GIS Officer
Forest Products Commission WA