Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Combining Text

jonathangonzales
8 - Asteroid
‎04-07-2016 01:21 PM

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
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎04-07-2016 01:34 PM
[family] + ' - ' + [desc]
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
dataMack
12 - Quasar
‎04-07-2016 01:35 PM

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

[Family]+' - '+[Desc]

Reply
Community Live Fifa Workshop
Labels
Top Solution Authors
View All