Concatenate every columns

[mpons]

Hi

I have a file with more than 700 columns that I have to concatenate.
I use the Aggregate action to group according to one column and I concatenate all the other columns.
Is there a way not to fill in all the columns one by one ?
The concatenation parameters are identical for all the columns.

Thanks

[dgudkov]

Hi Matthieu and welcome to the Community!

It seems like this topic can help you:

Which technique for grouping many columns of data together (i.e. 50+ columns)

I have some employee data in a csv file (approx 170,000 rows and 60 columns wide) and I need to “condense” the data to summarize the unique rows. Very simple example: Employee Department Status WageType John Department 1 Full time Salaried Joe Department 1 Part time Salaried Joanna Department 2 Full time Salaried Jeff Department 2 Full time Salaried Jessie Department 1 Part time Hourly Jenny Department 1 Part time Salaried Jamal Department 1 Par…

Let me know if it didn’t. In this case an example data set would be helpful.

[dgudkov]

Also, see this topic:

Aggregate for +500 columns

Hello, I hope you are all safe ! I have a question with the aggregate function. I have a large file (+500 columns) that I need to aggregate “by product” Exemple [1] and I need to have the Following output [2] How can I do this without having to tick all the columns one by one (as I did in my example) Thanks for your help Edward

[mpons]

Hi

It’s exactly that !

Thanks