Take data from new excel sheet and use it to update old excel sheet with the new info and remove old data that is not in the new excel sheet

Hey Everybody!

I hope all of you are having a great day so far!

I am having a bit of trouble with automating some excel work in UiPath Studio. I have a Live Pending Report Excel file that is continually updated… I have a Raw report Excel File that comes in once a week on Monday. I need to take the new rows the Raw report has and move it into the Live Pending Report. I then need to remove the rows that are in the Live Pending Report that are not in the Raw Report.

Thank you in advance for any info or assistance!

Have a great day!

Below are examples. Sorry about no data being in them. Got to follow company rules.

AaronLive Pending Report.xlsx (8.3 KB)
Raw Report 1.xlsx (8.3 KB)

welcome to the forum

we do need more details. Can you share some sample excel files with us? Thanks

1 Like

Thanks for replying! I posted samples. Apologies about them not having any data. Company confidentiality rules and what not. Thanks!

as both report have different column structures:

  • which column(s) is/ared used to identify that 1 row from raw report is belonging to a row in Live pending report

we respect poicies and also prefer to keep data confidental. But sample data can also be provided by masking sensitive data or dummy values.

Hello, The Purchase Document Column is the unique identifier