Hi folks,
I've created a map layout that pulls data from various fields in our new database. Everything is connected and working great now and all the data is coming across mostly correct. The one remaining hurdle I have right now is that when trying to pull data for System Supplier, System Installer and Owner(s) it displays the correct company names but it also carries over a bunch of blank values.
Like so (outlined in red):
My Arcade expression is as follows.
var role = $feature.ROLE_ID
If(role == 12){
return $feature.COMPANY_NAME
}
The intent is to check if a company is ROLE_ID 12 (System Supplier in this case) and return the Company name if it is.
Where I'm stuck is I am not sure why it is even accounting for other companies that don't match the ROLE_ID and fill up my data fields with blanks.
I'm sure it's something simple I'm overlooking but I've been staring at this all day and could use a fresh pair of eyes...
Accepted Solutions
That appears to be a dynamic text layout element. What you're seeing is being caused by the delimiter on the dynamic text. By default, the delimiter includes a whitespace character in addition to whatever you include.
When you define a delimiter, it will return all the values in the table, even the nulls, separated by that delimeter:
Since you're using an Arcade expression, try this:
var role = Boolean($feature.ROLE_ID == 12);
if(role){
return $feature.COMPANY_NAME + ', '
}
A bit better, but there's a pesky comma at the end of the string. Since your expression is simply filtering based on an attribute, it's simpler to add a Custom query to the dynamic text itself.
That appears to be a dynamic text layout element. What you're seeing is being caused by the delimiter on the dynamic text. By default, the delimiter includes a whitespace character in addition to whatever you include.
When you define a delimiter, it will return all the values in the table, even the nulls, separated by that delimeter:
Since you're using an Arcade expression, try this:
var role = Boolean($feature.ROLE_ID == 12);
if(role){
return $feature.COMPANY_NAME + ', '
}
A bit better, but there's a pesky comma at the end of the string. Since your expression is simply filtering based on an attribute, it's simpler to add a Custom query to the dynamic text itself.
Wow, yes this is absolutely what I wanted. Thank you!
