Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Concatinate

martman
7 - Meteor

Hi everyone

What’s the best way to concatenate address fields separated by commas with the blank fields ignored.

ie So out of the 6 Address Lines I could end up with something like this AddressLine1, AddressLine3, AddressLine6 in one field.

 

 

Thanks

Mart

2 REPLIES 2
MarqueeCrew
19 - Altair
19 - Altair

@martman,

 

Per your requirements:

 

[AddressLine 1] + 
IIF(IsEmpty([AddressLine 2]),"",", "+[AddressLine 2]) +
IIF(IsEmpty([AddressLine 3]),"",", "+[AddressLine 3]) +
IIF(IsEmpty([AddressLine 4]),"",", "+[AddressLine 4]) +
IIF(IsEmpty([AddressLine 5]),"",", "+[AddressLine 5]) +
IIF(IsEmpty([AddressLine 6]),"",", "+[AddressLine 6])

This will add the next line (preceded by comma & space) only if the field has data in it.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
Shark_Boy
5 - Atom

Thank you! This helped me with a similar problem I was having. 🍻

Labels