DataTable Join and Results

[hatakora (Hamdy Atakora)]

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
dt1
dt2

With the common Role ID from both dt1 and dt2, dt3 should be the following

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)
dt4

[Jacqui_M (Jacqui Muller (MEA))]

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

[hatakora (Hamdy Atakora)]

Corect. A left join was the solution actually

[ppr (Peter Preuss)]

Find link to the solution in the forked duplicated topic:

Compare Two dataTable With Massive Rows

@hatakora so the last tables were a good description. The task was perfect matching to the default activities e.g. Join DataTable, Filter Datatable For Special things we can fall back to alternates or LINQ For time reasons I prototyped with reduced sample set, but should work. Find Starter Help here: hatakora.xaml (13.8 KB)

[hatakora (Hamdy Atakora)]

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

[Jacqui_M (Jacqui Muller (MEA))]

Perfect I’m glad it worked!