How to get compare the datatable with another datatable

[manjula_rajendran]

Hi @keerthi_arumugam ,

Please find the modified workflow here.

Previous week wise Traffic new.xaml (20.5 KB)

[keerthi_arumugam]

some activity is missed @manjula_rajendran

[manjula_rajendran]

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

[Dawodm (Mahmoud Dawod)]

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
Mahmoud

[keerthi_arumugam]

Problem still exists

[manjula_rajendran]

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

[pravin_calvin (pravin kumar)]

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)).
CopyToDataTable()

Regards

[keerthi_arumugam]

Please Send screen shot of the flow.

[manjula_rajendran]

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, “-”}

[keerthi_arumugam]

Thank you

[manjula_rajendran]

is your problem resolved?

[Smruti_Smita_Samal]

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

[keerthi_arumugam]

yes…Thank you