Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

'& Ampersand' function to join cell contents.

m0s00ws
6 - 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

3 REPLIES 3
AndyBate
8 - Asteroid

Morning

 

Have you tried the plus symbol instead of the ampersand?

 

eg. [Container Type]+[Standard Shortname]

 

regards 

paul_houghton
11 - Bolide
As mentioned it's a simple + I'm alteryx
m0s00ws
6 - 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