Concatenate

[BillyL14]

Hi there

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

Thanks

[jdunkerley79 · Accepted solution]

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]

thanks

[Emil_Kos · Accepted solution]

Hi @BillyL14,

@jdunkerley79 is totally right. 

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

[BillyL14]

thanks!