Forum Discussion
Helper IICombining rows based on unique id, and combining information
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
Hi Imkef,
I have de same problem. Some rows have error "There were too many elements in the enumeration to complete the operation."
I show you a picture of mi example. What do you need to help me?
Hope you can help Me
Regards
Community ChampionHi Anonymous ,
These errors mean that you're trying to bring data into one row where there's actually more than one value per pivoted column. So you have to make up your mind and decide what to do with these multipe values: Combine then into one or delete them, because there are errors, create a separater table ... whatever is appropriate for your specific case.
To visualize the problem, you can add the following code as the 5th parameter to your Table.Pivot-function:
each Text.Combine(_, "#(lf)Additional Item: ")
This will create a line feed and a starting phrase for every multiple item in these rows.