Merge multiple rows in a report definition
I have a requirement as below:
If an operator ID has skills such as skill1, skill2... and so on, the current report definition displays this as follow:
operatorID_1 ---- SKILL1
operatorID_1 ---- SKILL2
We want to eliminate the no. of rows and include all the skills of a certain operator in a single row as below:
operatorID_1 ---- SKILL1, SKILL2, SKILL3..
How do I achieve this? I tried concatenate but I believe that's for grouping columns and not rows
Accepted Solution
Updated: 1 Apr 2024 4:03 EDT
Maantic Technologies Pvt Ltd.
IN
Hi @Ebhavya,
You can use a Data Page taken as source your Report definition and add a response data transform to fetch data from your report as Data Source and append it to the Data Page after concatenating your records based on primary key.
Maantic Inc
IN
Hi@Ebhavya
Please have a look in the below link, it might help to achieve your requirement.
https://support.pega.com/discussion/how-do-i-place-list-variable-one-line-seperated-commas
Accepted Solution
Updated: 1 Apr 2024 4:03 EDT
Maantic Technologies Pvt Ltd.
IN
Hi @Ebhavya,
You can use a Data Page taken as source your Report definition and add a response data transform to fetch data from your report as Data Source and append it to the Data Page after concatenating your records based on primary key.