Hello! I am looking to combine various elements of an address into one single column. For example the "base data" is available as so:
I want to end up creating a new column where each component of the address has been combined into a single phrase: "115 S Paul Dr"
An example by way of Excel: there is a formula to accomplish this (shown in formula bar) and the desired outcome shown in RED: "COMBINED_STREET_ADDRESS"
What is the Alteryx method to accomplish this item?
Solved! Go to Solution.
Create a new field in a Formula tool and use an expression similar to the following with all of the fields you want to concatenate:
tostring([street number]) + " "+ [prefix] + " " + [stree name] + " " + [street type]
Use the 'tostring()' function for the street number and any other field that comes through as a number. You could then use a Data Cleansing tool to get rid of the duplicate white space (for the instances where the original field was blank).
Hope this helps!
This absolutely works! Thank you!