Hi…
Currently it has got a task to excel reconciliation. And in below points I will mention the points. Could you please look into below and suggest a best approach for that.
-
Yesterday(let say 2020.09.06) it will update a excel file, generated via ERP(Let say 100 rows) with data rows using a RPA process. Then user will manually do some changes in the same excel file.[Refer below sample images]
-
Today(let say 2020.09.07) also excel file will create with data rows(let say 105 with 5 extra data rows)via ERP.
-
I want to use today newly generate excel file to do some task. But I want to add manually changed records in 2020.09.06 to today excel(2020.09.07 one).
-
Excel generate by ERP has around 10000 data rows[Make sense a lot of data in the excel].
Could some one please help me on the same. Thanks in advanced.