topic Re: Joining two layers in Dashboard in ArcGIS Dashboards Questions

Joining two layers in Dashboard

KendallJames73 — Fri, 16 May 2025 11:49:54 GMT

I hope someone can help. I'm learning Arcade and have been struggling with this one for a bit now.

ArcGIS Enterprise 11.3 Portal Dashboard app.

I have two polygon layers loaded into a Web Map, both are hosted feature services. Fuel Load and Compartments. They both have a LID field.

The web map is added to the dashboard. I want to create a Serial Chart in the Dashboard using a Data Expression, that joins these two layers on LID and returns fields from both that I can use.

I don't get any errors but once I click DONE, it says 'Unable to Execute Arcade Script.'

Any help will be appreciated.

// Replace with your actual Portal item IDs

var fuelItemID = "b1234567897c44428d5756461df44455"; // Clan Fuel Lod

var compItemID = "e9876543215143799cc23fe3018jhr89"; // Clan Compartments

// Access both layers

var fuelLayer = FeatureSetByPortalItem(Portal("https://gis.my.org.com/portal"), fuelItemID, 0, ["LID", "COMPNO", "FUELLOADS"]);

var compLayer = FeatureSetByPortalItem(Portal("https://gis.my.org.com/portal"), compItemID, 0, ["LID", "Plantation", "District", "SuperDistrict"]);

// Array to store joined features

var joinedFeatures = [];

// Join loop

for (var fuel in fuelLayer) {

var lid = fuel["LID"];

var match = First(Filter(compLayer, "LID = @lid"));

if (!IsEmpty(match)) {

var attributes = {

COMPNO: fuel["COMPNO"],

FUELLOADS: fuel["FUELLOADS"],

Plantation: match["Plantation"],

District: match["District"],

SuperDistrict: match["SuperDistrict"]

};

Push(joinedFeatures, {

attributes: attributes

});

}

// Define output FeatureSet schema

var fields = [

{ name: "COMPNO", type: "esriFieldTypeString" },

{ name: "FUELLOADS", type: "esriFieldTypeInteger" },

{ name: "Plantation", type: "esriFieldTypeString" },

{ name: "District", type: "esriFieldTypeString" },

{ name: "SuperDistrict", type: "esriFieldTypeString" }

];

// Return a proper FeatureSet

return FeatureSet({

fields: fields,

geometryType: "",

features: joinedFeatures

});

Re: Joining two layers in Dashboard

ZenMasterZeke — Fri, 16 May 2025 12:53:52 GMT

You may need double equals sign at 'First(Filter(compLayer, "LID = @lid"))'. Try First(Filter(compLayer, "LID == @lid")) for comparison.

Also, while Arcade doesn't have robust error handling, you can try Console(x) or return x after any group of statements to see what they are. I prefer return so that the rest of the script isn't executed. Console doesn't appear to return anything if there's an error anywhere in the script.

Re: Joining two layers in Dashboard

KenBuja — Fri, 16 May 2025 16:06:34 GMT

The sql expression in the Filter function uses a single "=".

Re: Joining two layers in Dashboard

KenBuja — Fri, 16 May 2025 19:11:44 GMT

Your logic works using this testing data, so I would use @ZenMasterZeke's suggestion to use Console (use the Run button to see the results in the Arcade window) to see what's not working

// Replace with your actual Portal item IDs var fuelItemID = "774019f31f8549c39b5c72f149bbe74e"; // states var compItemID = "5f31109b46d541da86119bd4cf213848"; // zip codes // Access both layers var fuelLayer = FeatureSetByPortalItem(Portal("https://www.arcgis.com"), fuelItemID, 0, ["STATE_ABBR", "STATE_FIPS"],false); console(fuelLayer) var compLayer = FeatureSetByPortalItem(Portal("https://www.arcgis.com"), compItemID, 3, ["State", "POPULATION", "ZIP_CODE"],false); console(compLayer) // Array to store joined features var joinedFeatures = []; // Join loop for (var fuel in fuelLayer) { console(fuel["STATE_ABBR"]) var lid = fuel["STATE_ABBR"]; var match = First(Filter(compLayer, "State = @lid")); if (!IsEmpty(match)) { console(match["POPULATION"]) var attributes = { COMPNO: fuel["STATE_FIPS"], FUELLOADS: match["POPULATION"], Plantation: match["ZIP_CODE"] }; Push(joinedFeatures, { attributes: attributes }); } } // Define output FeatureSet schema var fields = [ { name: "COMPNO", type: "esriFieldTypeString" }, { name: "FUELLOADS", type: "esriFieldTypeInteger" }, { name: "Plantation", type: "esriFieldTypeString" }, { name: "District", type: "esriFieldTypeString" }, { name: "SuperDistrict", type: "esriFieldTypeString" } ]; // Return a proper FeatureSet return FeatureSet({ fields: fields, geometryType: "", features: joinedFeatures });