Concatenate multiple columns with different data types into one

[jannet2014]

Hello,

I was wondering if there is a way to concatenate multiple columns with different data types without manually converting each data type into a string in the formula tool (I have approx 50 different columns)? 

Column A

Column B

Column C

Column D

Column E

Column F

Column G

Column H

Column I

Column J

Column K

Column L

Column M

Column N

Column O

Column P

Column Q

Column R

1

ABC

2

3

%

4

XYZ

12

##

12/8/2019

55

BHY

7

1/5/2020

3/5/2020

&&

444

IOS

The result I am looking for is below.

1ABC23%4XYZ12##4380755BHY74383543895&&444IOS

Thanks in advance!

[AbhilashR · Accepted solution]

Hi @jannet2014, you could use the Multi-Field formula tool to change the datatype and then use the combination of Transpose and Summarize tool to concatenate the data.

[FláviaB]

Thank you for your message, @jannet2014! I am moving your post to our Designer Discussion Board for more visibility. 

[jannet2014]

This works great! Thank you 🙂

[jannet2014]

@FlaviaB thank you!

[FláviaB]

Your are welcome, @jannet2014. Don't hesitate in reach out if you have any other questions. The Discussions board is the best way to start a new topic or look for something that might be already discussed. 😉