How to remove duplicates rows data from data table

Learning Initatives Automation Starter
21

To remove duplicate rows from a data table is like cleaning up a list so that each item is unique. Here’s a simple way to understand it:

  1. Look at Your List:
  • Imagine you have a list of items, like fruits.
  1. Find Duplicates:
  • Check if there are any fruits that are listed more than once.
  1. Keep Only One:
  • If you see a fruit more than once, just keep one of them. Remove the extra copies.
  1. Your List is Clean:
  • Now, your list has only unique fruits. No duplicates!

In terms of a data table, it’s like making sure each row has different information. You don’t want the same information repeated, so you clean it up by keeping only one of each.

22

Hi @T_Y_Raju ,

Use readrange activity
Store data in datatable
Use remove duplicate activity

U will have rows with unique values

Regards
AutomationXbyKiran