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.
This is one of my favourites :-)
1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls
2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column
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.
Amazing, this did exactly what I was looking for.
Thanks Imke!
