Build a Datatable with un matching column data

Help Studio
, ,
1

Hi ,
i m having 2 Datatables and i need compare “name” column and output the rows that doesn’t match match with dt2 COLOUME

Screenshot_1
Screenshot_11047×450 5.72 KB

2

Hi Tharusha,
Please do a left join…and check for rows with empty values from dt2…those are the records not present in dt2
If u still face ny issues lemme know
Thanks ,
Geetishree

1 Like
3

@gRao how can i build a table

4

You are already having datatables as per your query.
If not ,how r u getting the data,could u plz elaborate.
Dtatable can be built using Build Datatable activity, or when u do a ReadRange activtity from excel.

5

@gRao thanks brother i used filter data table after that to remove the empty rows

6

Great to hear this…
Thanks,
Geetishree Rao

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.