ebstarasia
IS-IT--Management
I have a list of reports/data that all contain one or more "event codes." What I am trying to do is compare the event codes in each data to the list of all possible "event codes" and have a list of what the data is lacking besides their reference number.
For example:
if the control or key set of event codes were {1,2,3,4,5}
i want to compare the following reports and have them return what code they are missing
Data A: {1,2,5} therefore next it would say {3,4}
Data B: {1,3} --> {2,4,5}
In a nutshell how would I write a relative complement of A (control set) & B (data)??
For example:
if the control or key set of event codes were {1,2,3,4,5}
i want to compare the following reports and have them return what code they are missing
Data A: {1,2,5} therefore next it would say {3,4}
Data B: {1,3} --> {2,4,5}
In a nutshell how would I write a relative complement of A (control set) & B (data)??