Update multiple fields using key field

Aнастасия88

Hello, I am just stack with preparing Arcade expression for immediate calculation. By the immediate calculation, I would like to update three fields based on a table's attributes via a key field when new creation or update of a existing feature.

I have prepared a code as per below but I will get an error as per below when I create a new feature. If anyone know a solution for this, match appreciated.

// Rule for asset_july_2023
// triggers: insert, update
// field: no select

// value of shared field
var key = $feature["Asset_NAME"]

// search for related features in tbl_asset_info feature class
var assInfFS = FeatureSetByName($datastore, "tbl_asset_info", ["*"], false)
var assInfFilter = Filter(assInfFS, "Asset_NAME = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/301813">@Key</a>")

var assTabList = []
var counter = 0
var numAsset = Count(assInfFilter)
if (numAsset > 0) {
    for (var asst in assInfFilter) {
        assTabList[counter] = {
            'attributes': {          
                'ASSET_ID': asst.ASSET_ID,                
                'TYPE': asst.TYPE,
                'VALUE': asst.VALUE
            }
        }
        counter++
    }
    return {
        'edit': [{
            'className': 'asset_july_2023',
            'adds':assTabList,
            'updates': assTabList
        }]
    }
} else {
    return 'No common asset in the asset info table.'
}

 

JohannesLindner

I would like to extract attribute from a table to update attributes of a point feature class 

Ah. Well, that is not what your original attribute rule does (and so it's also not what my rule does). These rules will do it the other way around: They will update/add a row in the table when you update/add a point in the feature class.

No worries, what you want is actually easier:

// Calculation Attribute Rule on asset_july_2023
// trigers: Insert, Update
// field: empty

// get the first related row from tbl_asset_info
var key = $feature.Asset_NAME
var asset_infos = FeatureSetByName($datastore, "tbl_asset_info", ["*"], false)
var asset_info = First(Filter(asset_infos, "Asset_NAME = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/301813">@Key</a>"))

// abort if no related row was found
if(asset_info == null) { return }

// return the related row's attributes
return {
    result: {
        attributes: {
            ASSET_ID: asset_info.ASSET_ID,
            TYPE: asset_info.TYPE,
            VALUE: asset_info.VALUE,
            }
        }
    }

 

The null check in line 11 will solve your error message.