Excel Duplication matching

Help Studio
, ,
1

Hello guys,

i have 2 excels i need to match the columns marked as green from the excel 1 to the excel2 and if there is any duplication it should add remarks in the sheet1.

image

It should match for this 2 column marked as green

2

@Sudharsan_Ka

Can you help me out on this

3

DT1.AsEnumerable.Any(Function(r) DT2.AsEnumerable.Any(Function(x) x(“Name”).ToString.ToLower.Trim.Contains(r(“Name”).ToString.ToLower.Trim)))
can you try this once gives output as boolean
thanks and regards

1 Like
4

I want to match “claim number” column and “plate number” column in excel 1 to the
“claim number” column and “plate number” column in excel 2.

And also i want to add Remarks in the First sheet as duplicate.

So can i use the same expression for this

5

yes you can try for second column values aslo

6

Check this…,

DT1.AsEnumerable.Any(Function(r) DT2.AsEnumerable.Any(Function(x) x(“Claim Number”).ToString.ToLower.Trim.Contains(r(“Claim Number”).ToString.ToLower.Trim)And x(“plate numbe”).ToString.ToLower.Trim.Contains(r(“plate number”).ToString.ToLower.Trim)))

thanks and regards
PARASA DINESH

7

@Dinesh_Guptil

i have so many transaction item it is not looping.

it is only checking for 1st line item.

8

Keep the query in for each row in datatable

Syntax :
DT2.AsEnumerable.Any(Function(x) x(“Name”).ToString.ToLower.Trim.Contains(CurrentRow(“Name”).ToString.ToLower.Trim)And x(“Email”).ToString.ToLower.Trim.Contains(CurrentRow(“Email”).ToString.ToLower.Trim))

1 Like
9

test2.zip (2.2 KB)

STILL THE SAME ISSUE ONLY READING THE FIRST ROW.

10

Your Syntax :
dt.AsEnumerable.Any(Function(x) x(“CLAIM NUMBER”).ToString.ToLower.Trim.Contains(CurrentRow(“CLAIM NUMBER”).ToString.ToLower.Trim)And x(“REGISTRATION NO”).ToString.ToLower.Trim.Contains(CurrentRow(“REGISTRATION NO”).ToString.ToLower.Trim))

my syntax :
dt2.AsEnumerable.Any(Function(x) x(“CLAIM NUMBER”).ToString.ToLower.Trim.Contains(CurrentRow(“CLAIM NUMBER”).ToString.ToLower.Trim)And x(“REGISTRATION NO”).ToString.ToLower.Trim.Contains(CurrentRow(“REGISTRATION NO”).ToString.ToLower.Trim))

11

ITS NOT LOOPING

12

ping me in linked in
url : https://www.linkedin.com/in/dinesh-parasa-8a6825231/

13

Dt.zip (2.1 KB)
PFA