Hi there, welcome to the board!
I want to make sure I understand this correctly before I press on towards a solution.
The file you posted, this is a master list? I understand the Tag Name is basically a unique/primary key while the other columns of data are not. So you will have this file, then you will get another file from the alarm system. It is with this other file that you want to check against the data you posted. What you want to check is what Tag Name's matched, along with a count? I'm not sure what you mean about the maount of time an alarm has being (been?) processed. I don't see any date/time values here. Would that come from the other file?
If you could also post a sample of the alarm file that would be helpful. Give us a little more information.
Bookmarks