Getting Row index using Data Table Select from another data table

Hi All,

I have 2 sample Data Tables.

The objective is to find the rows from dt2 to dt1. If there are no discrepancies, it passes (written in col-4 of dt1).

EDIT: I forgot to add screenshots my bad.
dt1 looks like this
dt2 looks like this
Is it possible to use dt1.Rows.IndexOf() using dt2.Select as a parameter?

Any solution is much appreciated.

Hi @avlavarias

Check this

Use Datable .Select("[Col1]<>’’ or [Col-2]<>’’ or [Col-3]=‘test’").CopyToDatatable
and then use build data table and add columns and bind the data by using add data row

Ashwin S