nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute Rule -Concatenate joins

AlexP_

Hello,

I have arcgis pro 2.7.2 and sde. I need to concatenate two fields in same feature class. I found a few samples from geonet. i tested it on my end by using attribute rule but it is not working. can you please assist? thank you.

Find more posts tagged with

Accepted answers

JoeBorgione

here's an example of one that I use:

// Specify the fields to concatenate

var values = [$feature.PreDir, $feature.StreetName, $feature.SufType, $feature.SufDir]
var combined_value = [];
// Loop through the field values and test if they are null or empty strings
// If they are not null or empty add them to an array
for (var i in values) {
    var value = values[i];
    if (IsEmpty(value)) continue;
    combined_value[Count(combined_value)] = value
}

// Return the field values concatenated with a space between
return Concatenate(combined_value, " ");

All comments

JayantaPoddar

Concatenate() function works for me. Double-click the function and fieldnames from above list to insert into the expression. Don't type it up.

Expression:

Concatenate($feature.Field1, " ", $feature.Field2)

$feature.Field1+" "+$feature.Field2

JoeBorgione

here's an example of one that I use:

// Specify the fields to concatenate

var values = [$feature.PreDir, $feature.StreetName, $feature.SufType, $feature.SufDir]
var combined_value = [];
// Loop through the field values and test if they are null or empty strings
// If they are not null or empty add them to an array
for (var i in values) {
    var value = values[i];
    if (IsEmpty(value)) continue;
    combined_value[Count(combined_value)] = value
}

// Return the field values concatenated with a space between
return Concatenate(combined_value, " ");

AlexP_

@JoeBorgione Thank you for the information. If I am understanding correctly, it looks like it will accept with null or no null during concatenate?

AlexP_

@JayantaPoddar Thank you for the information. what about if it is null? does it still show space like " " if it is null next to it?

JoeBorgione

You make a list of all the fields you want to concatenate; then step through that list, and if a given field is empty or null, you do not concatenate that into the returned output.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.