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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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