Merge datatable based on keywords

Help Studio
, , , ,
1

Hi All,

I have two tables like below
table1:
a b
hi 4
hello 5

table 2:
a b
4 yes
5 no
6 none

Expected outcome:

Table:
a b
hi Yes
hello no

how can i do the above.I wanna replace column b based on values from table2

2

Main.xaml (13.9 KB)

Hope this helps

1 Like