How to create a table in PEGA RPA

[SoumajitD17123628 (Soumajit Dey)]

How to create a table in PEGA RPA

[VANAMA_SANTHOSH]

@SoumajitD17123628

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.

[SoumajitD17123628 (Soumajit Dey)]

@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 :

[VANAMA_SANTHOSH]

@SoumajitD17123628

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.