Creating new column from all available columns.

[RVDL]

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.

[binuacs · Accepted solution]

@RVDL one way of doing this

[abacon]

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

Bacon

[RVDL]

@binuacs  Thank you.

[RVDL]

@abacon  

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.

[abacon]

@RVDL All good, I was making sure to answer your specific question and allowing for using that process for your specific use case. Glad you got it answered!

Bacon

[flying008]

Hi, @RVDL 

Another dynamic solution for you: