How to delete the row from datatable2 which has different value from datatable1

Help Studio
, ,
2

@shailesh1920

Welcome to the community

Follow the steps

  1. Create a new table dt3 and then use dt1.clone() in an assign activity
  2. Loop through dt2
  3. Inside loop use a filter datatable and filter dt1 on the currentrow("service number").tostring… and get to filterdt
  4. Use a merge dstatable to merge filterd rows filterdt to dt3

At the end of loop dt3 will have only the matching rows

Cheers