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!
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
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