Alteryx Designer Desktop Discussions

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

Concatenate

BillyL14
8 - Asteroid

Hi there

What would be the Aletryx version of Excels concat function be?

 

Thanks

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

There are a couple of options

 

For rows, you can use a summarize tool in concatenate mode

 

For columns, you can use a formula tool an then use a + between text fields to concatenate. For numeric fields you need to wrap with a ToString function.

 

If you have a sample of data and what you want to achieve happy to make a more concrete example

BillyL14
8 - Asteroid

thanks

Emil_Kos
17 - Castor
17 - Castor

Hi @BillyL14,

 

@jdunkerley79 is totally right. 

 

To make it simpler for you please find a sample workflow attached. 

BillyL14
8 - Asteroid

thanks!

Labels