Unsolved
This post is more than 5 years old
37 Posts
0
489
Collapsing Consecutive Duplicates?
A stream of records listing clients and their backup servers may have consecutive records with the same values (if a client is on the same server two intervals in a row). Is there a good way to collapse/merge identical rows while not losing records for the same client that show different servers?
| Header 1 | Header 2 |
|---|---|
| Input | Desired Output |
| client1:server1 | client1:server1 |
| client1:server1 | client2:server1 |
| cleint2:server1 | client2:server2 |
| client2:server2 | |
Help?