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
image
dt2 looks like this
image
Is it possible to use dt1.Rows.IndexOf() using dt2.Select as a parameter?

Any solution is much appreciated.
Thanks

Hi @avlavarias

Check this

or
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

Thanks
Ashwin S