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.
It should match for this 2 column marked as green
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.
It should match for this 2 column marked as green
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
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
yes you can try for second column values aslo
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
i have so many transaction item it is not looping.
it is only checking for 1st line item.
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))
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))
ITS NOT LOOPING