I am trying to filter the data in two excel sheets(E1, E2) based on ID, Date and Hours. If their is any data that is matching, it should be deleted from the collection and I will use the unmatched data for further processing. I did this using decision stage, comparing single row of E1 with single row of E2 - the code is all good and the process is elevated, working good. The issue is one of the Excel file has 59,000 rows and this is consuming lot of time. I am finding a way to minimize the time and Utility- Collection Manipulation VBO has an option to filter. But the filter condition is not working and is throwing me different errors - Please help me with the logic here :
"[EE ID]= "& [Crew_Member_ID]&" AND [Date Absent]=" & [Time_Off_Date] & " AND[Sedgwick Hours]=" & [Units_Requested]
"[EE ID]= "& [Crew_Member_ID]&" AND [Date Absent]=" & [Time_Off_Date] & " AND[Sedgwick Hours]=" & [Units_Requested]