eimon
(eimon)
October 26, 2021, 8:05am
1
I am doing Query the data records from the data service(uipath) and paste those records in the excel.
1.Querydata , data type is IList<>
2.CreateDataTable
3.Assign those IList<> in the for each.
4.add datarow
5.make output datatable
I dont know how to assign in Step3.
Thanks in advance
Sincerely
what inside the List is here.
List(1) { OrderReceived { Company=βAAAβ ,
CreatedBy=SystemUser { CreateTime=[03/08/2021 06:23:09 +00:00]
, Id=[2addfc8f-de5a-4d21-b261-d159bc609e8f], IsActive=true, Name=ββ¦β, Type=User, UpdateTime=[03/08/2021 06:23:09 +00:00] }, CreateTime=[10/25/2021 09:33:42 +00:00], DelieveryDate=[10/21/2020 00:00:00], Id=[efea2da4-7635-ec11-981f-dc98402f8053], InCharge=βeβ, OrderDate=[12/13/2021 00:00:00], OrderNO=β1β , ProductName=βetβ, Quantity=β1β, Total=β133β, Unit=β133β, UpdatedBy=SystemUser { CreateTime=[03/08/2021 06:23:09 +00:00], Id=[2addfc8f-de5a-4d21-b261-d159bc609e8f], IsActive=true, Name=ββ¦β, Type=User, UpdateTime=[03/08/2021 06:23:09 +00:00] }, UpdateTime=[10/25/2021 09:33:42 +00:00] } }
eimon
(eimon)
October 26, 2021, 8:08am
2
I assign this , but got the wrong answer. It should get βAAAβ not βDβ.
The result of query records may be one or more records
Thanks you again
ppr
(Peter Preuss)
October 26, 2021, 8:20am
3
depending on that all bold marked properties are all columns from the databal you can start with following:
assign Activity
RowArrayList | List(Of Object) =
(From x in OutputRecords
let c = x.Company
let d = x.DeliveryDate
let p = x.ProductName
let q = x.Qantity
Let t = x.Total
Let u = x.Unit
Let ra = new Object(){c,d,p,q,t,u}
Select a=ra).toList
wthin a for each you can interate over RowArrayList | item in RowArrayList
and can use item within an add datarow for the RowArray
1 Like
eimon
(eimon)
October 26, 2021, 8:33am
4
Thank you so much for the reply @ppr
For my lack of understanding , i do not get the point.
Yes,Only the bold marked data(Company,Total⦠from the IList)
would be paste in the excel sheet.
Where do i assign this?
RowArrayList | List(Of Object) =
DataServiceJuchushitsuryoku.zip (15.9 KB)
ppr
(Peter Preuss)
October 26, 2021, 9:42am
5
@eimon
as an alternate
Set typeArgument to OrderReceived
e.g. Company
Complete your assign activity by:
CompanyName = item.Company
1 Like
eimon
(eimon)
October 26, 2021, 9:56am
6
Hello Mr.Peter@ppr
Thank you so much.
The problem was solved with your help.
I can eat dinner finally
Sincerely and have a good day
system
(system)
Closed
October 29, 2021, 9:56am
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.