1. I want to compare two excel sheets having 7 columns or conditions. It can have many fields in it, many fields can have same names but with different field IDs having 7 different conditions for them. I need to compare a row in the same excel sheet / different excel sheet and split the fields as "Reused fields" and "New fields".
Thanks for your reply Andrey, Plz find the attachment from my original discussion. I want the fields to be grouped based on the business grouping but it should satisfy all the conditions (Qualifier/Enumeration,Data type,Min occurs,Max occurs,M/C/O and Length).