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.
Hi Matthieu and welcome to the Community!
It seems like this topic can help you:
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.
Also, see this topic:
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”
and I need to have the Following output
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