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.
Hi Imke, thanks so much for your help so far!
This seems to get me part of the way there, but the resulting values (after pivot) are only 0 or 1instead of the dates.
Example:
id | StartDate | FollowupDate | FinishedDate |
101 | 1 | 1 | 1 |
102 | 1 | 0 | 1 |
103 | 1 | 0 | 0 |
If I change type to date, the results are not accurate, all in 1899.
Does anyone know what I can try?
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 am trying to find the solution to this thread without success.
Could you share it?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.
Amazing, this did exactly what I was looking for.
Thanks Imke!
