Datatable Comparison -

[ppr (Peter Preuss)]

@Manikandasamy
give a try on following:

• Use Join DataTable activity - Join type: Inner, dt1 to dt2 (out:dtJoin)
• define a String Array with the Columns which you want to keep from dtJoin - arrCols
• get result table by: dtJoin.DefaultView.toTable(false,arrCols)

the first requirement description was showing also the unmatched rows from dt2 in the result (hint for Full Join)
the second requirement description is showing the only common rows (hint for inner Join) and a selection of needed columns (hint for selecting with default view)

Also have a look here:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…