Combine Various Columns into one New Column (Opposite of Text to Column)

Question

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?

Kenda · Accepted Answer

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!