Correct expression for matching and output?

[ppr (Peter Preuss)]

@Parvathy

(From row In dt1
Join row2 In dt2

@Nyx

(From row In dt1
Join row2 In dt2

In Addition to the above

When working with a LINQ statement never omit the appended AsEnumerable() when working with DataTables

Statement started with an inner join

Left: COLLECTION_CONTROL_KEY-Fin = Right: COLLECTION_CONTROL_KEY-Col

As only the matching rows will be passed to the further processing there will no be Non-Matchers which makes the below obsolete

@Nyx

Let key = If(row(“COLLECTION_CONTROL_KEY-Fin”).ToString() = row2(“COLLECTION_CONTROL_KEY-Col”).ToString(),“Match”,“No Match”)

Before stepping in other possible correction needs we recommend to focus on the overall goal. Maybe you can share it with us along with some sample data

Also have a look here for the different join types:

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…