I have two excel files. I need to iterate through the first one but during iteration i need to check if the value of the column “Company” contains in the second mapping excel file (and it might be modified there). If that’s the case i need to take the value from the second mapping excel file. This is happening because there are errors in the first excel file and that’s why i have mapping document.
eg. First Excel file:
Second excel file:
As you can see there is difference in the company. In the first file i have “Interworks BT” and in the second file only “Interworks”. So in this case i need to take the value from the second filefor processing. That is the correct value. Any solution for this?