How match two data table with common column and update second columns

Help Studio
1

I have two datatable and i need to get data from 1st datatable and update to second datatable.

For Each r As datarow In dt_Ergo_Mort.AsEnumerable
If dt_Matched_Ergo_Mort.AsEnumerable.Any(Function(a) (a(“CERTIFICATE_NO ANALYTICS”).ToString).trim.equals(Decimal.Parse(r.Item(“INSU_POLICY_NO”).ToString.Trim,System.Globalization.NumberStyles.Any).ToString)) Then
r(“Quote”)=a(“Policy_No Analytics”)
End If
Next

2

Try the below approach:

For Each Row r in dt_Ergo_Mort:
matchRow = (From a In dt_Matched_Ergo_Mort.AsEnumerable() Where a("CERTIFICATE_NO ANALYTICS").ToString().Trim() = Decimal.Parse(r("INSU_POLICY_NO").ToString().Trim(), System.Globalization.NumberStyles.Any).ToString() Select a).FirstOrDefault()
If matchRow IsNot Nothing
r("Quote") = matchedRow("Policy_No Analytics")
3

this is my first datatable

The image shows a Microsoft Excel spreadsheet containing data on insurance certificates and policies, including renewal premiums and sums insured. (Captioned by AI)
The image shows a Microsoft Excel spreadsheet containing data on insurance certificates and policies, including renewal premiums and sums insured. (Captioned by AI)1405×718 60.8 KB

this is my second datatable
image
image1379×688 52.2 KB

A column is common in both sheets and i need take B,C,D columns and put in second datatable columns:- B=AR,C=Av and D will go in AW

4

Hi @nishant.pandey ,

if possible can you share your excel files and will prepare code for you

5

You can use vLookup, it will compare rows based on the common column in both and you can fill the desired columns based on any condition.