Concatenate where a cell is empty or null
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there,
I'm trying to concatenate some address fields but the columns I am using are the content is not uniform and is spread across 3 columns.
In the example above, I know how to concatenate buildingNumber with the DoubleThoroughfare&descriptor field. But where DoubleThoroughfare&descriptor field is empty I want to concatenate buildingNumber with the Thoroughfare&descriptor.
Is there a way of dong
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JamesDB
Use ISNULL in a IF statement and you will be able to get it.
Sample formula
if isempty(DoubleThoroughfare&descriptor) then
concatenate buildingNumber with the Thoroughfare&descriptor
Else concatenate buildingNumber with the DoubleThoroughfare&descriptor endif
I can build you a sample workflow 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JamesDB ,
Here is the exact formula
IF IsEmpty([DoubleThoroughfare&descriptor])
THEN ToString([buildingNumber])+"-"+ [Thoroughfare&descriptor]
ELSE ToString([buildingNumber])+"-"+ [DoubleThoroughfare&descriptor]
ENDIF
Output:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's saved a lot of time and effort.
Thank-you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂
Cheers and happy analyzing 😀
