Getting Row index using Data Table Select from another data table

[avlavarias (Alvin Lavarias)]

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.
Thanks

[AshwinS2 (Ashwin S)]

Hi @avlavarias

Check this

How to get the row index through selecting another datatable?

Hi everyone, I want to add two data column to a datatable from another one like this. [sample_datatable] My aproach is here. Step1. Use “For each row” activity with dt2 and get dt2.row(0) and dt2.row(1). Step2. Select dt1 and get row index. Step3. Use “Add data column” activity and add dt1.row(2) and dt1.row(3). Step4. Assign dt2.row(0) to dt1.row(2) or (3). (this step will also use the same method) I have no idea of Step2 method. Best regards.

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