Logic suggestions for comparing 2 csv's

[cubangt]

Not making a file, just need to filter the ping results against our ticket system data and return ticket counts and ticket numbers by store.. No additional file is needed or being created, just need the counts and ticket #'s for any store that has any reported tickets about registers. Format doesnt matter, only that way in my post for better understanding of what im trying to accomplish..

the end result will be presented in a HTML file.
But my main ask is how to look at the support ticket file and see if any of the "Down" registers already have tickets opened.