I have data in data sheet. I’m using for each row to loop through the data. When there is a duplicate I need the bot to recognize and input the data in a field with a space and a letter to distinguish the 2 or 3. How do I get it to recognize and perform this action? thanks in advance

HI @brettthompson , They way I often do this is by having the robot keep a list of the values it has come across before. As it iterates through the data it is adding the value into the list so it ‘remembers’ having seen the value before. Then you can use that list to decide whether to perform additi…

in general we can do this by grouping the data and then process the group members of the different groups. When processing the group, we can realize the counter of the member which it had within its group can you share some sample data or giving more info how many cols are involved for the duplicat…

Hi @brettthompson , Refer below link [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(…

8100 8100 8100 I need the bot to recognize that this is a duplicate on the loop around and when it inputs the data it should look like this 8100 c 8100 c 8100 c adds an extra space to distinguish

will it didn’t add the extra spaces. But the first should have one space the 2nd has 2 spaces and the third has 3

Hi @brettthompson , You can follow something similar to below logic. 1. Start 2. Initialize a ItemList of type List<string>/DataTable 3. for each row in InputTable: ItemNotFound = True; while ItemNotFound: index=0; if(row(item).ToString() present in ItemList): index++; continue; if(r…

For each row data

Help Activities

arivu96 (Arivazhagan A) January 14, 2022, 3:05pm 5

Hi @brettthompson,

Refer below link

Regards,
Arivu

Topic		Replies	Views
Removing duplicates in the same column Help datatable , excel , activities , question	9	2837	December 4, 2019
Skip duplicate row in each Activities excel , each	5	1050	March 10, 2023
Identifying Duplicate number and changing associated number Help datatable , excel , activities	14	6862	September 18, 2017
Need to remove complete row if duplicate find in the specific column Studio studio , question , activities_panel	4	214	February 20, 2024
Check for Duplicate Rows Help activities	15	4409	November 6, 2019

For each row data

Related topics