Join two data tables and if column values matched ,need to get column values from right table

Learning Initatives Reboot Your Skills 2021
1

dt
dt1115×507 7.41 KB

Hi , I need to compare “name” and “class” in two data tables, if rows are matched just need to merge “head” and “count” columns into dt1.(Note: “s.no” field is not a primary key)

2

Hi,

Hope the following sample helps you.

img20210517-2
img20210517-2905×882 38.6 KB

Sample20210517-1.zip (15.3 KB)

Regards,