Add column values from one datatable to another basis a condition

[ppr (Peter Preuss)]

inner join will only handle the common rows between dt1,dt2
in case of Acc No. and Date columns details from Dt2 should be blank within the result for rows not found in dt2 we would use a left join:

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…

we would recommend to start with the join datatable activity and post processing the join result by e.g removing unneeded columns

In case of a LINQ is wished, then please clear the requirement of handling unmatched rows within dt2