Loop through record by record in a DataTable
Hi,
I have script which returns a DataTable. How to loop through every record in a DataTable.
Thanks
Phani
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
US
Which product are you using to do this?
Accepted Solution
Infosys
AU
If this is Pega Robotics ( Openspan ),
you could either do it in another script / component using .NET code which would be the easiest to write / maintain.
If you must do it in an automation, then you could use a forLoop ( DataTable.Rows.Count as Limit ) - Extract DataTable proxy and so on. Refer attached automation segment.
Tata Consultancy Services
US
It's Openspan. Thank you Kartik.
ATIT
SA
hi All.
Are we talking about Pega Data table in here or is it a different scenario?
thank you.
Tharindu
Virtusa
LK
Hi All
Could you guys clarify on how to retrieve the datatable object from the toolbox window in pega robotics studio
Pegasystems Inc.
US
You cannot add a DataTable to the Toolbox directly. In the screenshot above that was a proxy generated by right-clicking the blue dot representing a DataTable and selecting Extract Proxy.