Merge multiple rows in a report definition

User Experience
, , , , ,
1

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

2

Hi@Ebhavya

Please have a look in the below link, it might help to achieve your requirement.

3

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.

4

@SrijitaB Thanks i’ll try that