SOLVED
'& Ampersand' function to join cell contents.
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
m0s00ws
6 - Meteoroid
‎01-04-2018
11:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi team,
Seems like a simple enough task but I can't seem to figure out or find a solution to the problem at hand.
As seen below when I try to join the contents of the two columns the resulting values are all shown as 0.
Any ideas on how I can fix this?
Thanks
MS
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
3 REPLIES 3
AndyBate
8 - Asteroid
‎01-04-2018
11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Morning
Have you tried the plus symbol instead of the ampersand?
eg. [Container Type]+[Standard Shortname]
regards
paul_houghton
12 - Quasar
‎01-05-2018
01:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As mentioned it's a simple + I'm alteryx
‎01-11-2018
06:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Andy,
Thanks for the response and solution! was simple enough.
I did try that before but it kept coming back with the wrong solution because I had the field setting on double rather than as a string.
Cheers!
MS
![](/skins/images/1A7F54316481E10DBCA4A87A32E06CC6/responsive_peak/images/icon_anonymous_message.png)