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***
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.
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.
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.