DataTable Join and Results

Hello thanks in advance for the help on this as well. I am having an issue with comparing two datatables and getting the result i need. See attached an example
dt1 and dt2 are the initial tables. dt3 and dt4 is what i am trying to get
dt1Screen Shot 2020-06-03 at 2.18.23 PM
dt2Screen Shot 2020-06-03 at 2.18.40 PM

With the common Role ID from both dt1 and dt2, dt3 should be the following
Screen Shot 2020-06-03 at 2.19.20 PM

And dt4 should be the opposite or difference ( essentially everything where the role id from dt1 and dt2 are not the same and the commonality is that this datatable will be anything without a role owner)
Screen Shot 2020-06-03 at 2.20.44 PM

Hi @hatakora

I hope you are well.

Have you played around with the Join Data Table activity?

It allows you to get the items in both datatables (inner join) as well as data that is in one table and not the other (outer join).

I suspect this will assist in this process


Corect. A left join was the solution actually

Find link to the solution in the forked duplicated topic:

1 Like

@ppr i did. Please find my comment on that post

Perfect Iā€™m glad it worked!

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