Forum Discussion
Combining 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.
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
I am trying to accomplish something similar and when I hit Ok after selecting Don't Aggregate, my data returns Errors.
When I click on the Error Link, it says "There were too many elements in the enumeration to complete the operation."
Any suggestions?
Thanks!
R
This is due to the fact that the column you've checked (where you say: "Unpivot others") would have duplicates after the operation / there would be more than 1 value in a cell.
I need to see a sample of your data to tell you how to overcome this.
Hi,
I may need to create a new post as this is quite a bit outdated but I am trying something similiar and need some assistance.
Here is my data:
UserName UserEmail Office LoginDate LoginTime ViewedScreen Type Location Shareholder LetterDate UniqueID Smith, John [email protected] 2 5/8/2018 0:00 15:35:51 Y 19523C53 Y 1 FL Williams, Gary 5/8/2018 4:00 19523C53 Y 1 GA Smith, John 5/8/2018 4:00 19523C53 I am using the patch/collect function in powerapps to spit this data to an excel workbook. It informs me if a user has viewed a screen, what selections they made in a dropdown etc.
My issue is as follows: A user may make multiple selections in the dropdowns and I need to track that data. (Type, Location, Shareholder & LetterDate)
As you can see in the data table above, it will collect Y for they viewed the screen, what drop down selections were made and a uniqueID for that specific session of them using the app.
I'm wondering what the best way is for me to link that data to the UniqueID but still individually be able to track the different drop-down selections, but mash together the viewscreen columns since I don't care about the duplicate Ys so long as I have one Y, but I do need the specific selections from the dropdowns to report on.
I would create 2 tables which will be connected in the data model via UniqueID:
1) Header
2) Details:
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
Hi 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.
