How to get column values matched rows based on cloumn values

Help Studio
1

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
2

@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 - #2 by Latif

If not you can share your sample excel to check

Hope this helps you

Thanks

3

You mean merging data tables?

4

Hi @thima,

Here is the workaround for you.

Hope this helps.

PFA - ExcelCalc.zip (10.6 KB)

Thanks :slight_smile:

5

Hi,

I tired using data tables, pls check.

Regards,
Vijayendraowner.zip (20.6 KB)