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 should look at the end like this:
June 25, 2021, 8:09am
give a try on Join DataTable (Join Type: full Join)
and adopt afterwards the Join Result (datacol adoptions, Empty value formats …)
Could you please explain? And there are only inner, left and full join type
June 25, 2021, 8:15am
yes full join (aka outer join)
Have a look here:
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:
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.
The INNER JOIN keyword selects records that have m…
But it adds all the columns and I need to add only values and not the ID column
June 25, 2021, 8:22am
this we can cleanse afterwards very easy
Could you explain how or give me an example?
June 25, 2021, 8:30am
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
June 25, 2021, 10:55am
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
dtJoin.AsEnumerable.Where(Function (x) String.IsNullOrEmpty(x(“ID”).toString))
Feel free to enhance by:
“0” instead of Blanks
Find starter help here:
Demo_JoinDataTable.xaml (9.8 KB)
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
June 28, 2021, 7:58am
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
July 1, 2021, 7:58am
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.