How to get column values matched rows based on cloumn values

Hi All,

I have datatable 1 which has below columns
image
i have another datatable which has below columns
image

I want to get owner id values from data table 2 and paste in datatable 1

out put should be below
image

Please some one help me

Regards,
Hima

1 Like

@thima

To get a row value and Set the value, Check as below
RPA DataTable: Get Previous Row Column Value, Set to Current Row Column Value

If not you can share your sample excel to check

Hope this helps you

Thanks

You mean merging data tables?

Hi @thima,

Here is the workaround for you.

Hope this helps.

PFA - ExcelCalc.zip (10.6 KB)

Thanks :slight_smile:

Hi,

I tired using data tables, pls check.

Regards,
Vijayendraowner.zip (20.6 KB)