merging multiples layers in a unique list widget with arcade

DISIG — Wed, 10 Nov 2021 10:16:04 GMT

Hello everybody,

For a dashboard i would like to merge two layers with arcade data expression to display the result in a unique list widget (i have to minimize the number of widgets and clicks to keep my users aware...)

i tried to adapt the code from the arcade git. but i don't know if it really could work in a list widget.

any ideas?

here is the code :

var portal = Portal("https://www.arcgis.com/"); 
var notations = FeatureSetByPortalItem(portal,"9abab4147fbb4d708c7058e4269b12f7",0,['RD','TXT_ANNEE','NOTE','CumulD','CumulF','OBJECTID'],false) 
var travaux = FeatureSetByPortalItem(portal,"162565e07fc745ae94dbb33fafed250a",0,['RD','TXT_ANNEE','NATURE','CUMULD','CUMULF','OBJECTID'],false) 
var i = 0; 
 var combinedDict = { 
    fields:[ 
        {name : "identifiant",type : "esriFieldTypeInteger"}, 
        {name : "source",type : "esriFieldTypeString"}, 
        {name : "rd",type :"esriFieldTypeString"}, 
        {name : "legende",type :"esriFieldTypeString"}, 
        {name : "annee",type :"esriFieldTypeString"}, 
        {name : "CumulD",type :"esriFieldTypeString"}, 
        {name : "CumulF",type :"esriFieldTypeString"}, 
    ], 

    geometryType:"", 
    features:[], 
}; 

for (var n in notations){ 
    combinedDict.features[i] = { 
        attributes: { 
            identifiant : ["OBJECTID"], 
            source : "notation", 
            rd : n["RD"], 
            legende : n["NOTE"], 
            annee : n["TXT_ANNEE"], 
            CumulD : n["CumulD"], 
            CumulF : n["CumulF"], 
        }, 
    }; 
    i++; 
}    
for (var n in travaux){ 
    combinedDict.features[i] = { 
        attributes: { 
            identifiant : ["OBJECTID"], 
            source : "travaux", 
            rd : n["RD"], 
            legende : n["NATURE"], 
            annee : n["TXT_ANNEE"], 
            CumulD : n["CUMULD"], 
            CumulF : n["CUMULF"], 
        }, 
    }; 
    i++; 
} 
return FeatureSet(Text(combinedDict));

topic merging multiples layers in a unique list widget with arcade in ArcGIS Dashboards Questions

merging multiples layers in a unique list widget with arcade