Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Combine/Join/Append?

Highlighted
6 - Meteoroid

Hi Everyone,

 

I would like to append the data in column A to the beginning of column B.  How can I accomplish this?

 

djspring_0-1581622473071.png

I've tried both the Append Fields and Join tool and nothing seems to be working.

 

Sorry for the repeat question, but I'm having a hard time find my original post from yesterday, so I'm not sure if there was a response.

Thanks!

Alteryx Partner

This is really easy @djspring ,

 

just use a formula tool. If the data-type is a String-type, the + Operator will do everything you need.

reply_mueller_0-1581623281812.png

 

Best,

 

Johannes

Highlighted
6 - Meteoroid

Hi,

 

I re-created your flow and it worked!!  The key here is ensuring the file type is String.  Otherwise, the numbers are just added together.

 

Thanks so much for you help!

Labels