Join Data Tables

[Montse09 (Maria)]

Hello,
I have a question regarding joining two data tables.
For example, say you have Table A and Table B, joined by a common field. I want to create a data table for all records in table A that are NOT listed in Table B.
I can’t figure out how to get the resulting data table using the Join Data Table activity.
Any help would be appreciated, thank you!

[Palaniyappan (Forum Leader)]

Hi
Welcome to UiPath community
In join datatable activity we can get the matching records between two datatable either from one or both
To get the unmatched data kindly have a view on this thread

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Cheers @Montse09

[ppr (Peter Preuss)]

@Montse09
For your scenario DataSet Operations will be helpfully:
Step 1: find the common rows between dt1 and dt2 based on a common column:

• can be done with a join on statetement

Step 2: Find out the records in dt1 that are not listed dt2 = dt1 without the rows from step 1

• can be done with an Except statement

If you need additional help so just post some sample data. We will help you on your implementation