Linq in Data Tables

datatable
uiautomation
linq

#1

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"), 
               .Data1 = DT1.Field(Of String)("Data1"), 
               .Data2 = DT1.Field(Of String)("Data2"),
               .Data3 = DT2.Field(Of String)("Data3"), 
               .Data4 = DT2.Field(Of String)("Data4")
            }).ToList()

I used 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?


#2

Did you find any answer for this.?


#3

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

Regards,
Arivu


#4

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


#5

i got the solution thank you


#6

Hi Divya,
Can you share the solution


#7

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