We need all the application names which are not registered for the particular Change Request. And we need to send email to respective application groups.
List A | |
CR No | App Name |
CR1 | APP1 |
CR1 | APP2 |
CR1 | APP3 |
List B | |
App Name | |
APP1 | Email1 |
APP2 | Email2 |
APP3 | Email3 |
APP4 | Email4 |
APP5 | Email5 |
OUTPUT: Non matching rows for the particular change request from both the list
App Name | |
APP4 | Email4 |
APP5 | Email5 |
|
|
Note: In SO association we have option to get ONLY matching data.