Hi, it may be an overkill but was trying to write a LINQ that will join 3 DataTables within Invoke Code activity. Can someone guide me in the areas marked as “help here” so that the result of LINQ is stored in vbResultDataTable and returned to workflow.
I am struggling to capture and process the List of “anonymous type”.
vbResultDataTable = New Datatable()
With vbResultDataTable
.Columns.Add(“ID”,GetType(String))
.Columns.Add(“Account”,GetType(String))
.Columns.Add(“Description”,GetType(String))
End With
Dim vbResultRows As help here =
(From File1 In vbFile1.AsEnumerable()
Join File2 In vbFile2.AsEnumerable()
On File1.Field(Of String) (“ID”) Equals File2.Field(Of String) (“ID”)
Join File3 In vbFile3.AsEnumerable()
On File1.Field(Of String) (“ID”) Equals File3.Field(Of String) (“ID”)
Select New With {
.ID = File1.Field(Of String)(“ID”),
.Account = File1.Field(Of String)(“Account”),
.Description = File1.Field(Of String)(“Description”)}).ToList()
Dim obj As Help Here
For Each obj In vbResultRows
Dim dr As DataRow = vbResultDataTable.NewRow()
dr(“ID”) = obj.Item(“ID”) help here
dr(“Account”) = obj.Item(“Account”) help here
dr(“Description”) = obj.Item(“Description”) help here
Next
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil