'& Ampersand' function to join cell contents.

Question

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

AndyBate · Accepted Answer

Morning

Have you tried the plus symbol instead of the ampersand?

eg. [Container Type]+[Standard Shortname]

regards

paul_houghton · Accepted Answer

As mentioned it's a simple + I'm alteryx