Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Concatenating two fields using Regex

RickRick9901
5 - Atom

Hello all,

 

I am trying to concatenate two fields. I first parsed one column into four separate ones and now I am trying to combine two of the columns that I made, including add a hyphen "-" in between them. Example:

 

Original columns:

 

Japan              2

AUS               19
GER               10

US                   5

ARG               21

 

New resulting column:

Japan-2

AUS-19

GER-10

US-5

ARG-21

 

Any assistance is appreciated. Thank you

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Can you use a formula tool that creates a new field? Your formula would look like the following with Field 1 and Field 2 switched with the column names that you want to use. 

 

[Field 1] + "-" + [Field 2]

Qiu
20 - Arcturus
20 - Arcturus

@RickRick9901 
How about a formula Tool?

Capture123.PNG

Labels