Hi, I need to join two tables using linq, Dim vLINQ = (From DT1 In vDT1.AsEnumerable Join DT2 In vDT2.AsEnumerable On DT1.Field(Of String)("Key") Equals DT2.Field(Of String)("Key") Select new with { .Key = DT1.Field(Of String)("Key"), …

Did you find any answer for this.?

Hi @Divyashreem , @ddrdushy1 Refer this Post Join Two Data table [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(O…

i need to join 3 tables here, and i had written linq query but it is throwing an error

Hi Divya, Can you share the solution

Linq didnt, work for me as well, i used simple 3 for loops one inside the other.

Hi Divya, Can you post the solution.

i have used For loop inside another for loop that’s all.

Using Linq is possible for joining 3 data table. Please find the below sample query. (from a in Company1 join b in Company2 on a (“EMPId”).Tostring() equals b (“EMPId”).Tostring() join c in Company3 on c.(“EMPId”).Tostring() equals b.(“EMPId”).Tostring()) select a)

Hi, I have two datatables with huge volume of data around 2 Lakhs (Min) in datatable 2 and around 1 lakh data in datatable 1. I need to compare three columns in two datatables , if all the values in two datatable matches, (account) column value from datatable 2 needs to be updated in the account co…

Linq in Data Tables

Help

arivu96 (Arivazhagan A) March 27, 2018, 6:37am 3

Hi @Divyashreem,
@ddrdushy1
Refer this Post Join Two Data table

Regards,
Arivu

Topic		Replies	Views
Joins using Linq Help activities	13	12987	March 11, 2023
Linq Query Issue Reboot Your Skills 2021 datatable , uiautomation , activities , studio , week-4	11	1567	May 6, 2021
Join 3 Datatable into 1 Studio datatable , excel , activities , studio	6	148	August 16, 2024
Extract and join data tables StudioX datatable , studiox , question	8	335	April 2, 2024
How to join two datatables using LINQ inUipath Tutorials activities , studio , faq , linq , other-products	0	2424	October 6, 2022

Linq in Data Tables

Related topics