How to get Consolidated output using Bursting data model

Summary:

Hi Team,

I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule the report employee is receiving multiple emails for different courses.

My concern is to get the list of courses in a single email not to trigger multiple emails based on the no of courses employees have.

Below is the query used for this:

SELECT DISTINCT

PAPF.PERSON_NUMBER as "KEY",

'notification' TEMPLATE,

'en-US' LOCALE,

'HTML' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'Overdue Learnings' OUTPUT_NAME,

'dileep.dasari@kovaion.com'PARAMETER1,

''PARAMETER2,

'Quess Corp'||' '||'eumz-test.fa.sender@workflow.mail.ap1.cloud.oracle.com'PARAMETER3,