Comparing two excels with 400K rows each

[Jobin_Joy]

Hi @jvarghese9689

Can you please look into the below thread?

Quick way to compare two excel files

Hi all, I have an excel sheet with 6000+ rows in it and I need to compare it another excel file and update a status as Match or Unmatch. I don’t want to write a VB script and For each Row iteration is taking a lot of time to update status . What can I do to update status so that my flow completes ASAP as thats the business requirement . Any inputs shall be much appreciated , Thanks in advance!

Hope this will be useful. Thank you.