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

ABC

XYZ

12/8/2019

BHY

1/5/2020

3/5/2020

444

IOS

The result I am looking for is below.

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

Thanks in advance!

Preparation

Accepted answers

AbhilashR

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.

sample.yxmd

All comments

AbhilashR

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.

sample.yxmd

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 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703