Merge datatable based on keywords

Hi All,

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

table 2:
a b
4 yes
5 no
6 none

Expected outcome:

a b
hi Yes
hello no

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

Main.xaml (13.9 KB)

Hope this helps

1 Like