Compare two tables and add column

[markosc]

Hi,
I have two tables which I need to compare. If they have same rows in column A then I need to add data from the second to the first row for each row they match ID. In second table there are always new values (new ID and and new values) which also need to be added.

Table1:

Table2:

Table1 should look at the end like this:

[ppr (Peter Preuss)]

give a try on Join DataTable (Join Type: full Join)
and adopt afterwards the Join Result (datacol adoptions, Empty value formats …)

[markosc]

Could you please explain? And there are only inner, left and full join type

[ppr (Peter Preuss)]

yes full join (aka outer join)
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…

[markosc]

But it adds all the columns and I need to add only values and not the ID column

[ppr (Peter Preuss)]

@ppr

and adopt afterwards the Join Result (datacol adoptions, Empty value formats …)

this we can cleanse afterwards very easy

[markosc]

Could you explain how or give me an example?

[ppr (Peter Preuss)]

Sure, Lets suggest following:
You will create a XAML with two build datatables (dt1,dt2) along the demo data from above
We will pick up your XAML and enhance it for demo example

[markosc]

data.xlsx (12.8 KB)

[markosc]

Any idea???

[ppr (Peter Preuss)]

please give me little time. Your excel differs from screenshot data as there are IDs in dt2 not present in dt1. So we have harmonize the join result

like this:

dtJoin.AsEnumerable.Where(Function (x) String.IsNullOrEmpty(x(“ID”).toString))
dtJoin.DefaultView.ToTable(False, {“ID”,“A”,“B”,“Column1”,“C”,“D”,“Column2”,“ASD”})
Result:

Feel free to enhance by:

• “0” instead of Blanks
• any orderings

Find starter help here:
Demo_JoinDataTable.xaml (9.8 KB)

[markosc]

And could you please give me an idea when the robot does this every month?
So after the dtResult is created I write two more columns with formulas, then the next month robot needs to read that datatable and do the same thing by adding column with new data

[ppr (Peter Preuss)]

On the first view it looks that it should be handleable by enhancing it with some dynamics (e.g. column array for the dtResult.Select etc.

We would suggest to keep the topics clear on case and in case of further open questions open a new topic on this new case. It would help if sample date for the two months are proivded. Thanks