Skip to main content
With String concatenator, can I only concatenate an output for rows where data is null or blank in a different field? Example: I have a field with addresses, only some entries are null or blank. I do have house numbers and street names in their own respective fields for every entry.  I want to concatenate ONLY rows where the full address field is null or blank
Hi,

 

 

I think there are at least two approaches:

 

1. Use a Tester to determine if the full address field is null or blank; concatenate strings for Passed features with a StringConcatenator.

 

2. Use the Conditional Value setting functionality of the AttributeCreator. If the full address field is null or blank, create a concatenated string and assign it to the field. Otherwise, do nothing.

 

 

Takashi

Reply