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
Community ChampionThat'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 ?
alexsimpsonHelper I
Hi all, I am having very similar problems to the above, as you can see below the Id numbers are sorted in order and there is data in different columns:
Then when you follow the process mentioned.... After the first step, something weird happens:
Then when you apply the second stage they all become errors:
It feels like there is something really simple to fix here?