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"),
.Data1 = DT1.Field(Of String)("Data1"),
.Data2 = DT1.Field(Of String)("Data2"),
.Data3 = DT2.Field(Of String)("Data3"),
.Data4 = DT2.Field(Of String)("Data4")
assign activity to achive this. UIPath showing error as
Option Strict On disallows late binding.
how I can Use this type of LINQ in UIPath?
Did you find any answer for this.?
Refer this Post Join Two Data table
Use below code to remove empty row from the table.
Use assign activity
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()
Re-usable Component pass Parameter as datatable you will get the answer.
RemoveEmptyRows.xaml (8.5 KB)
Remove rows based on particular column is empty.
DataTableName.Select("Convert(column3, System.String)< >''"…
i need to join 3 tables here, and i had written linq query but it is throwing an error
i got the solution thank you
Can you share the solution
Linq didnt, work for me as well, i used simple 3 for loops one inside the other.
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)
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 column in datatable 1.Since the query is wrote is taking too much time. Help me to find a solution for this.