Skip to main content
Solved

Using the String Concatenator...

  • April 30, 2014
  • 1 reply
  • 106 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
View original
Did this help you find an answer to your question?
<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Evangelist
  • 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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings