I am running search against a database that includes a username and ticket count (from our ticketing system). When the results come back, I have one user who is listed with multiple iterations of their name. For example:
John Q User 5
John Quser 3
John User 6
These are all the same user, so I would like to combine the names into a single entry (as "John Q User"), and combine the counts for each entry to reflect (from the above example) the total count of 14.
Any help would be very much appreciated.
Is there another field (like email address) available from the database that would link common entries?