How to automate export file functionality and compare data with web app data

[poojas]

I need help in which BOT has to click on export the excel file and once file is downloaded, Open that excel file and compare the downloaded data with data available on Web application

I have done code till download excel file however if export button clicks multiple time, file name changes to filename(number) e.g. number =1,2,3 etc…

Can any one assist in this.?

[GreenTea]

Hi @poojas,

Please create two more folders: Processing and Completed
After the file is downloaded, Move File activity to move downloaded file to Processing folder and compare with Web application. When file comparison completed, move file to Completed folder.

[poojas]

Hi thanks for the suggestion
However if I keep exporting, File gets downloaded in the same folder , thus it get the suffix as Export1, 2, 3… and so on. How to handle this situation that only downloaded latest excel file should get moved to processing folder and BOT should not consider the existing file.

[GreenTea]

Hi @poojas,

Use 2 Assign activities to determine the latest timestamp of the downloaded file.

[poojas]

Thank you