Concatenating Text

Hi All,

Happy Friday!..I am trying to join text ( first name,middle name and last name ) into a separate column with the first name ,middle name and last name seperated by a space...Can you please let me know what formula needs to be used to accomplish this in alteryx..

Thanks,

Arun

Common Use Cases

Accepted answers

All comments

patrick_digan

@arunchandra You can use the + sign when working with strings to concatenate:

[FirstName] + " " + [MiddleName] + " " + [LastName]

iceman

Hello,

I need help in the getting the needed output.

Please see below screenshot.

Need to get output

hannahhanigan

Where at do you create the concatenate? The logic makes sense, but I'm not sure where to actually create it at.

cbehret001

Not everyone has a middle name.

I was running a Text To Columns to eliminate middle initials... IIF(Length([TempName2]) == 1, Null(), [TempName2])... so I wound up with some Nulls in the 2nd column and some Nulls in the 3rd column.

This longer version of Concatenate makes sure you do not have any unnecessary spaces.

[TempName1]

IF (IsNull([TempName2]))
THEN ""
ELSE " " + [TempName2]
ENDIF

+
IF (IsNull([TempName3]))
THEN ""
ELSE " " + [TempName3]
ENDIF

rshynn

This was super helpful, thank you. I've seen this in multiple training modules but failed to piece things together.

franc1s

You could do away with the summarize as Vishwa outlined in his answer by configuring the crostab tool as follows.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703