Compare two tables and write data only for same values

[markosc]

Hi, I have two tables with same and different values in column a. I need to write values from dt2.
Dt1:

Dt2:

Final dt:

[arivu96 (Arivazhagan A)]

Hi @markosc ,

Kindly refer below link, use join data table activity to join the table, you can provide the conditions in join wizard.

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards,
Arivu

[Srini84 (Srinivas Kadamati)]

@markosc

You can use Join Datatable activity where you can give the condition as “a” = “a”

Hope this may help you

Thanks

[markosc]

No because with join the result is like this:

[Srini84 (Srinivas Kadamati)]

@markosc

You can check with different join Types, Try with Left and let us know

Hope this may help you

Thanks

[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”