Linq for Compare Two Columns in Different DT and Update in DT1

[pikorpa (Piotr Kołakowski)]

Hey @Manii_K

Please try this project:
BlankProcess22.zip (35.1 KB)

You can also use this example of linq:

(From row In dt1.AsEnumerable()
 Let filledRegion = If(String.IsNullOrWhiteSpace(row("Region").ToString.Trim),
                       dt2.AsEnumerable().
                          Where(Function(r2) r2("Unit").ToString = row("Unit").ToString).
                          Select(Function(r2) r2("Region").ToString).
                          FirstOrDefault(),
                       row("Region").ToString)
 Select outputDT.Rows.Add({filledRegion, row("Unit").ToString})
).CopyToDataTable()