Remove duplicate from data table based on filter

Help Studio
, ,
1

I need to remove duplicate from data table based on filter.
For example in the below image, 124 is duplicated in ClaimNumber column but subject is different. If there is duplicate, i want to compare with subject column and keep the required rows. Could anyone suggest a linq for this.?

image

2

Removing Duplicates.xaml (8.3 KB)
Hi @balaji.murali ,

Please find the attached xaml file. I have builded the query as per your requirment. Pleasea try to use the xaml file and let me know is this working or not?
Thank You!

3

Welcome to UiPath Forum @balaji.murali :pray:t3:

What about this Linq

Input
image

Output
image

Workflow

image
image1162×778 36.7 KB

Code

(From row In dt.DefaultView.ToTable(True,"ClaimNumber").AsEnumerable
Let r = If(dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").Count>1,
If(dt.Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"'").Count>0,
dt.Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"'").CopyToDataTable.Rows(0).ItemArray,
dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").CopyToDataTable.Rows(0).ItemArray),
dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").CopyToDataTable.Rows(0).ItemArray)
Select dt2.Clone.Rows.Add(r.ToArray)).copytodatatable

Xaml
Sequence4.xaml (9.7 KB)

reqSubject = YourRequiredValue

Thanks,

4

Hi @RajKumar_DC

Thanks for the solution. It is working as expected.
I have multiple subjects to filter. How to add that?

5

Hi @balaji.murali,

just add your condition like below i have add one more column “NewColumn”

Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"' and Convert(NewColumn, System.String)='"+reqSubject+"' ").CopyToDataTable.Rows(0).ItemArray

6

I need to check like this…
subject =‘aaa’ or subject =‘abc’

7

Hi @balaji.murali ,

so use “or” Condition

dt.Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"' or Convert(subject, System.String)='"+"bbb"+"'")

(From row In dt.DefaultView.ToTable(True,"ClaimNumber").AsEnumerable
Let r = If(dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").Count>1,
If(dt.Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"' or Convert(subject, System.String)='"+"bbb"+"'").Count>0,
dt.Select("Convert(ClaimNumber, System.String)='"+row("ClaimNumber").ToString+"' and Convert(subject, System.String)='"+reqSubject+"'").CopyToDataTable.Rows(0).ItemArray,
dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").CopyToDataTable.Rows(0).ItemArray),
dt.Select("Convert(ClaimNumber,System.String)='"+row("ClaimNumber").ToString+"'").CopyToDataTable.Rows(0).ItemArray)
Select dt2.Clone.Rows.Add(r.ToArray)).copytodatatable

Thanks,

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.