Question

Hello, I am trying to figure out how to deal with duplicate entries in an Excel spreadsheet using a loop action. Can anyone help me with this? I need to watch a video to help me learn this. Please help. Thank you.

  • 27 October 2022
  • 1 reply
  • 27 views

Hello, I am trying to figure out how to deal with duplicate entries in an Excel spreadsheet using a loop action. Can anyone help me with this? I need to watch a video to help me learn this. Please help. Thank you.

1 reply

Userlevel 3
Badge +7

Hi @Steven Holyome​ ,

 

 In A2019/A360 there is an option for data table. You can take the complete data into a table variable and then perform "remove duplicate rows" command on the table. After that you can write the new datatable into the excel file.

 

Remove duplicate rowsDeletes duplicate rows (if any exist). Select the Table variable name from the drop-down list.

 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-data-table-command.html

Reply