0 votes
1 view
in RPA by (5.3k points)

This is to create a bot that updates the existing CSV file with the latest available data from the new CSV file that is downloaded at regular intervals.

I am unable to figure out the logic. Need your help.

Step 1: I am accessing the following website,https://www.marketwatch.com/tools/stockresearch/globalmarkets/intIndices.asp

Step 2: I am downloading the Tables from the above website and saving a .CSV file.

Step 3: I am comparing the OLD .CSV file with the NEW .CSV FILE and updating the values in the OLD .CSV.

Step 4: If there were changes made there is a status column and in the corresponding row I need to update "Value Updated" or "Latest Value Exists"

1 Answer

0 votes
by (9.5k points)
  • Our aim is to save the list individually, so open the csv in different session and get the column in different lists.

  •  Compare both the lists.

  • use if condition that updates the value, if satisfies the condition.

  •  Use this link  for using a bot https://botstore.automationanywhere.com/bot/excel_comparison/


Welcome to Intellipaat Community. Get your technical queries answered by top developers !