topic Re: Arcade - Join features attribute in ArcGIS Dashboards Questions

Arcade - Join features attribute

junaidjawaid — Tue, 30 Aug 2022 06:11:53 GMT

Hi, I am trying to combine the attributes from two layers hosted in the ArcGIS server with following code in Arcade Data Expression . In both layers, the fields on which the join will based is of the same data type i.e. String. The expression is returning following error.

// Create empty features array and feat object
var features = [];
var feat;

for (var t in CS) {
var tableID = t["ID"]
for (var p in Filter(DTS, "FEEDERID = "+tableID)){
feat = {
attributes: {
Name: t["Name"],
}
}

Push(features, feat)
}
}

var joinedDict = {
fields: [
{ name: "Name", type: "esriFieldTypeString" },
],
'geometryType': '',
'features':features
};

// Return dictionary cast as a feature set
return FeatureSet(joinedDict);

Error Snapshot :

Re: Arcade - Join features attribute

JohannesLindner — Tue, 30 Aug 2022 08:30:46 GMT

The field type is string, so your SQL filter expression should look for string values. You have to enclose your tableID with single quotes:

for (var p in Filter(DTS, "FEEDERID = '"+tableID+"'")){ //... }

Better yet, let Arcade handle the types:

for (var p in Filter(DTS, "FEEDERID = @tableID")){ //... }

Re: Arcade - Join features attribute

junaidjawaid — Tue, 30 Aug 2022 09:30:21 GMT

Hi Johannes,

Thanks for your suggestion, now a different error is shown as below:

Execution Error:Invalid Parameter

Re: Arcade - Join features attribute

JohannesLindner — Tue, 30 Aug 2022 09:37:39 GMT

FeatureSet() needs a json string, not a dictionary. Try this:

return FeatureSet(Text(joinedDict));