Skip to main content
Solved

Using the String Concatenator...

  • April 30, 2014
  • 1 reply
  • 126 views

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

Best answer by takashi

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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • Best Answer
  • May 1, 2014
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