Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Combining Text

jonathangonzales
8 - Asteroid

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
2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
[family] + ' - ' + [desc]
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
dataMack
12 - Quasar

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

[Family]+' - '+[Desc]

Labels
Top Solution Authors