Concatenate Numbers Columns Using Semicolon

[Shan_Drex12]

Hi All,

I'm having trouble concatenating numbers in a given column to express it with semicolons.

Check Below:

F1
1938813
1941389
1941382
1941530
1942941
1943184
1943638
1943636

But I want a semicolon between each string

1938813;1941389;1941382;1941530;1942941;1943184;1943638;1943636

I would appreciate the help! 🙂 

** Update** thank you all, this was a huge help 🙂 

[AngelosPachis · Accepted solution]

Hi @Shan_Drex12 ,

I've mocked up a workflow that answers your question.

Output

You need a field to become your column header and then you can use the cross-tab tool. Let me know if that worked for you.

Regards,

Angelos

[Maskell_Rascal · Accepted solution]

Hi @Shan_Drex12 

You can use the Summarize tool to concatenate, and even change the separator to your liking! Just make sure to convert the column you're wanting to concatenate to a string first. I'd recommend a V_WString, since it will adapt to character size as needed. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[Qiu · Accepted solution]

@Shan_Drex12 
Basically same with @AngelosPachis , but I did not use Record ID.
The Summarize Tool will concatenate the rows if the input is a string.

[grazitti_sapna · Accepted solution]

Hi @Shan_Drex12 , as there is no specified criteria so I assume you are just trying to concatenate a single column, so here are 2 possible solutions that I can think of.

I hope this helps and mark this post as solution if it works for you.

Thanks.

[Qiu]

@Shan_Drex12 
Thank you for the mark also. Have a good one.