Creating new column from all available columns.

Hi All,

Suppose I have 10 columns called FLD1, FLD2, FLD3, etc.

I use a Formula tool to create a new column called ID which appends the values from the 10 columns. Thus my formula looks something like: [FLD1] + "_" + [FLD2] + "_" + [FLD3] + ... + [FLD10]

Suppose I now have 100 columns, and I want my ID column to contain the concatenation of the values in each of these 100 columns. Is there a way to create the ID column without typing out all the specific column names ( [FLD1] + ... + [FLD100] ) in a formula?

Thanks.

Workflow

Accepted answers

@RVDL one way of doing this

Concate_28072025.yxmd

All comments

@RVDL one way of doing this

Concate_28072025.yxmd

@RVDL I went the same route. You will need to transpose the columns into 1, then concatenate them using your seperator.

Bacon

Creating New Column From all Available.yxmd

@binu_acs Thank you.

This solution concatenates all records into a single cell. Thus:

	Test1	Test2	Test2
1	One	Two	Three
2	Four	Five	Six

gives:

Record	Concat_Value
1	One_Two_Three_Four_Five_Six

I needed the concatenation to happen for each record in the data. Thus:

Record	Concat_Value
1	One_Two_Three
2	Four_Five_Six

Maybe it wasn't clear from my ask. I'll try to be more specific next time when asking a query. Thanks for the quick response though.

Hi, @RVDL

Another dynamic solution for you:

录制_2025_07_29_08_08_29_8.gif

Quick Links

Tags

This months top contributors

Hollingsworth 335