I have two excel files (attached here). The goal is to remove all rows from EBS OA Update Template_final_06022020.XLSX which do not match with EBS OA Update Template.xlsx,
based on columns “Purchasing Document” and “Item” of EBS OA Update Template_final_06022020.XLSX with “OA Number” and “OA Line” of EBS OA Update Template.xlsx
@rahul.lakshmanan There’s a Problem in your Excel I feel, We cannot have Same Column Names in Excel File and in one Excel some of your Columns have Same name
@supermanPunch let me take a look at the same. Yes i know that the column names are same in the excel sheet and i have mentioned the same in the problem title