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 Imke,
I tried your solution for one of my data which i need in same format.
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
But its giving error "There were too many elements in the enumeration to complete the operation.". Can you please help?
Regards,
Shruti
- ImkeF
Community Champion
That's because your table is missing a unique identifier that determines the row.
Imke - perhaps you can help me with a similar situation. I am also trying to combine data like the previous users but mine would be by date and I want the sum of the numbers instead of just a count. It looks like the aggregate only gives a count?
The situation is multiple locations entering data into different tables on the same date and I would like to combine those into a global sum for each attribute being tracked while having accurate monthly/quarterly numbers.
- ImkeF
Hi Anonymous ,
Not sure I can follow. Could you please share (link to) some sanitzed sample data ?
I had the same problem but i solved it by adding this after step 1:
1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls
1.1) Select Column ID and Attribute together -> mouse right click -> remove duplicates
2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column (Advanced Options: Don't aggregate bofore hitting the last OK.)
