ernestaigner
New member
- Joined
- Jun 19, 2014
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Hi,
I have a table with about 10000 entries and 30 Columents. Each row has an ID where about 4000 rows have the same ID. These rows are exactly the same except 6 columns in which they have binary (empty or 1) information. I would like to merge duplicate rows and if one of them has a "1" in a certain column, the merged row shall also have a 1.
How can I do that? I tried now for about 2 hours, but don't find a soluation. I tried by sorting a checking whether the next row has the same entry. However, since sometimes there are three rows which are the same except the binary value, this approach is not working. I am happy for any suggestions!!!!
I also google alreay, however, not successfully. Maybe I am looking for the wrong thing.
THANK YOU!!!
Ernest
I have a table with about 10000 entries and 30 Columents. Each row has an ID where about 4000 rows have the same ID. These rows are exactly the same except 6 columns in which they have binary (empty or 1) information. I would like to merge duplicate rows and if one of them has a "1" in a certain column, the merged row shall also have a 1.
How can I do that? I tried now for about 2 hours, but don't find a soluation. I tried by sorting a checking whether the next row has the same entry. However, since sometimes there are three rows which are the same except the binary value, this approach is not working. I am happy for any suggestions!!!!
I also google alreay, however, not successfully. Maybe I am looking for the wrong thing.
THANK YOU!!!
Ernest