Compare two tables and write data only for same values

[ppr (Peter Preuss)]

@markosc

@markosc

No because with join the result is like this:

Use a Full Join datatype

Your case is a typical Join scenario. But only use = as operator
About Join types 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…

After joining the datata (result: dtJoin DataTable) just remove the unneeded Columns added by the Join activity by

• using a Filter datatable (Col removal configuration)
• dtJoin.DefaultView.ToTable(False, {“a”,“b”,“b_1”})

Rename later b_1 ColName to c by

YourDataTableVar.Columns(“b_1”).ColumnName = “c”