I am trying to read an excel sheet and filtering only Emp Id, First and Last name. I am able to do this using Filter Data table. However I have to cross check this data based on Empid in another excel having multiple columns like Emp id, Joining, Requestor, Approver, Status.
Now I have to match all emp id from Excel 1 to matching records in Excel 2 based on Emp id.
Requirement is that there could be more than 1 records in excel 2 having emp id.
Any suggestion how to filter and match records…