Alteryx Designer Desktop Discussions

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

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

[family] + ' - ' + [desc]

Alteryx ACE & Top Community Contributor

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

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

[Family]+' - '+[Desc]

learn more about the python upgrade coming in may 2024

Alteryx Designer Desktop Discussions

Combining Text