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.
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.
Hi Anonymous ,
Not sure I can follow. Could you please share (link to) some sanitzed sample data ?
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?
