SOLVED
Combining Text
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jonathangonzales
8 - Asteroid
‎04-07-2016
01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Join
2 REPLIES 2
20 - Arcturus
‎04-07-2016
01:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
[family] + ' - ' + [desc]
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
dataMack
12 - Quasar
‎04-07-2016
01:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Connect a Formula tool and name the new field 'Together' and make it a string. Your formula would be:
[Family]+' - '+[Desc]
