How to create a table in PEGA RPA
Here’s a general process:
- Drag and drop the DataGrid control from the toolbox onto your automation canvas.
- Define the columns in the DataGrid properties. You can specify data types like String, Integer, etc.
- To populate the table, there are multiple options:
- Manually add rows using the DataGrid’s “Add Row” method.
- Use scripting to iterate through existing data structures (like Lists or Arrays) and dynamically add rows with corresponding values.
- If dealing with external data sources (like web tables), explore Pega RPA’s web scraping features to extract data and populate the DataGrid.
@VANAMAS16755149 in my case, the columns are dynamic, the task is basically to fetch a table from a web page whose rows and columns can change with time. Then to put that table in excel file and save it. Till now i have done like this :
1.Kindly check the Interrogation with match rules.
2.Use Lookup table for adding rows and columns after that import into excel
3.Replace data grid with import excel table.