How to add values from one specific column to another column of datatable

[M1288 (Meg1288)]

Hello everyone,

Can anyone please help,

I am having 2 datatables
1 st datatable
city, id
City1,
city2,
city3,

2nd datatable
id
123
234
345

i want to update the id value from 2nd datatable to 1st datatable in “id” column.

expected output
City, id
city1, 123
city2, 234
city3, 345

Thanks in Advance.

[ppr (Peter Preuss)]

one of many options:

[M1288 (Meg1288)]

Hi @ppr,
Thank You it worked.