How to get compare the datatable with another datatable

Hi @keerthi_arumugam ,

Please find the modified workflow here.

Previous week wise Traffic new.xaml (20.5 KB)

1 Like

some activity is missed @manjula_rajendran

It could be a loading problem. Close UiPath studio and open again. If problem still exists let me know

1 Like

Please watch these two videos about comparing two datatables.
Compare with C#: UiPath | Compare Two Datatables in UiPath with C# Code | Compare Collections with C# | Comparing - YouTube
Compare with LINQ: UiPath | Compare Two DataTables with LINQ | Function Intersect | Function Except | Function Union - YouTube

Best regards

Problem still exists

I’ve created a complete new process for you. Just extract and try. (43.2 KB)

Hi @manjula_rajendran

Please Try the below Linq Code.

MatchedDT (DataTable) = Dt1.AsEnumerable().Where(Function(row)  Dt2.AsEnumerable().
Select(Function(r) (r.Field(Of String)("Columnname")).Trim.ToUpper).Any(Function(x) x = (row.Field(Of String)("ColumnName")).Trim.ToUpper)).


Please Send screen shot of the flow.



dtTemp= dtAllCountry.AsEnumerable.Where(Function(r) r(“Country”).ToString.Trim.ToUpper = row(“Country”).ToString.Trim.ToUpper).CopyToDataTable

add data row values {row(“Country”).ToString, dtTemp.Rows(0)(“Sessions”)}

Catch part
Add data row values {row(“Country”).ToString, “-”}

1 Like

Thank you

1 Like

is your problem resolved?

1 Like

There are 2 to 3 href link in web pages. How to get one of them ?

yes…Thank you

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.