community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

'& Ampersand' function to join cell contents.

Meteoroid

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? 

Sample 1.pngSample 2.png

 

Thanks 

MS

Highlighted
Asteroid

Morning

 

Have you tried the plus symbol instead of the ampersand?

 

eg. [Container Type]+[Standard Shortname]

 

regards 

Alteryx Certified Partner
As mentioned it's a simple + I'm alteryx
Meteoroid

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

Labels