https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486341#M9766 <P>You're missing the layerid in line 3</P> Thu, 06 Jun 2024 15:57:54 GMT KenBuja 2024-06-06T15:57:54Z https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486265#M9762 <P>I am trying to write a data expression to return fields from 2 different data layers. My data expression looks like this:</P><LI-CODE lang="c">var portal = Portal('https://piercecowa.maps.arcgis.com'); var thira = FeatureSetByPortalItem(portal,'aff5dd7c9615404cac256ec6dc627e10', ['*'],false) var poete = FeatureSetByPortalItem(portal,'aff5dd7c9615404cac256ec6dc627e10', 1, ['*'],false) // Create empty features array and feat object var features = []; var feat; for (var x in poete){ var ParentGlobalID = x["parentglobalid"] var poete_area = x['poete_area'] var Name; var UASI_Jurisdiction; var Community; var Core_Capability; var Target for (var y in thira ){ if (y["globalid"] == ParentGlobalID){ Name = y['Name'] UASI_Jurisdiction = y['Jurisdiction'] Community = y['Sub_Jurisdiction:'] Core_Capability = y['core_capability'] Target = y['target'] break } } feat = { attributes: { Name: Name, UASI_Jurisdiction: UASI_Jurisdiction, Community: Community, Core_Capability: Core_Capability, Target: Target, poete_area: poete_area } } Push(features, feat) } var joinedDict = { fields: [ { name: "ParentGlobalID", type: "esriFieldTypeGUID" }, { name: "poete_area", type: "esriFieldTypeString" }, { name: "Name", type: "esriFieldTypeString" }, { name: "UASI_Jurisdiction", type: "esriFieldTypeString" }, { name: "Community", type: "esriFieldTypeString" }, { name: "Core_Capability", type: "esriFieldTypeString" }, { name: "Target", type: "esriFieldTypeString" }, ], 'geometryType': '', 'features':features }; // Return dictionary cast as a feature set return FeatureSet(Text(joinedDict));</LI-CODE><P>poete_area data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dwold_0-1717684998588.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/106367i3104972C9B8B55DA/image-size/medium?v=v2&amp;px=400" role="button" title="dwold_0-1717684998588.png" alt="dwold_0-1717684998588.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dwold_3-1717685477633.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/106372iFA23651EDB52A685/image-size/medium?v=v2&amp;px=400" role="button" title="dwold_3-1717685477633.png" alt="dwold_3-1717685477633.png" /></span></P><P>&nbsp;</P><P>thira data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dwold_1-1717685392392.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/106370i68B28CA773DA6CBB/image-size/medium?v=v2&amp;px=400" role="button" title="dwold_1-1717685392392.png" alt="dwold_1-1717685392392.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dwold_2-1717685424501.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/106371i7D846FCCBA8B8331/image-size/medium?v=v2&amp;px=400" role="button" title="dwold_2-1717685424501.png" alt="dwold_2-1717685424501.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dwold_4-1717685523239.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/106373iE7F0FF92D75740AB/image-size/medium?v=v2&amp;px=400" role="button" title="dwold_4-1717685523239.png" alt="dwold_4-1717685523239.png" /></span></P><P>&nbsp;</P> Thu, 06 Jun 2024 14:52:30 GMT https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486265#M9762 dwold 2024-06-06T14:52:30Z https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486341#M9766 <P>You're missing the layerid in line 3</P> Thu, 06 Jun 2024 15:57:54 GMT https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486341#M9766 KenBuja 2024-06-06T15:57:54Z https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486555#M9771 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/2839">@KenBuja</a>&nbsp;thanks!!</P> Thu, 06 Jun 2024 19:53:12 GMT https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-to-join-two-layers-to-be-used-in/m-p/1486555#M9771 dwold 2024-06-06T19:53:12Z