Identify Duplicate and alter duplicate by adding no. in front of them

Help Activities
, , ,
1

hello Community I want to identify the duplicates and then alert thode no with adding numbers in front of them and incrementing those no. according to duplicate numbers of value
FOR EXample
INPUT:
image
Output:
image

2

@Prateek_Pathak

  1. Read Data:

    • Use the “Read Range” activity if your data is in an Excel file, or use “Read Text File” if it’s in a text file.
    • Store the data in a variable, let’s call it numbersList.

  2. Identify Duplicates:

    • Use the following LINQ query to identify duplicate numbers:
      numbersList.GroupBy(Function(x) x).Where(Function(g) g.Count() > 1).Select(Function(y) y.Key).ToList()
    • This will give you a list of duplicate numbers.

  3. Add Numbers in Front:

    • Use a For Each activity to iterate through each duplicate number in the list.
    • Inside the loop, use a For Each activity again to iterate through each occurrence of the duplicate number in the original list.
    • While iterating through each occurrence, add a number in front of it to differentiate it. You can use a counter variable to increment the added number (index+2).

  4. Write Back:

    • Write the modified list back to your desired destination using the appropriate activity (“Write Range” for Excel, “Write Text File” for text files).
3

Find below workflow which will help you to get expected output

image
Adding Number in front of Duplicates.zip (4.6 KB)

4

Simply use below query
Assign: opDt=Inputdt.clone
Assign: opDt=

(From row In Inputdt
Group row By a = row(“Value”).ToString().Trim() Into grp = Group
From g In grp.Select(Function(r, index) New With {r, index})
Select If(grp.Count() = 1,
opDt.Rows.Add(g.r(“Value”).ToString()),
opDt.Rows.Add(g.r(“Value”).ToString() + “_” + (g.index + 1).ToString()))
).CopyToDataTable()

Thanks
Tushar