In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
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
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All