Combining Text

[jonathangonzales]

Hello,

 I am trying to combine 2 fields with a character in the middle.

in excel it would look like.    =A2&" - "&B2

How can i do that formula in alteryx?

Family	Desc	Together
Cheese	Dip	Cheese - Dip
Cheese	Packaged	Cheese - Packaged
Cheese	Gouda	Cheese - Gouda
Cheese	Soft	Cheese - Soft

[MarqueeCrew · Accepted solution]

[family] + ' - ' + [desc]

[dataMack · Accepted solution]

Connect a Formula tool and name the new field 'Together' and make it a string.  Your formula would be:

[Family]+' - '+[Desc]