How to get information in pivot table for repeated entries in comma separated form?

[Anonymous]

Hi ,

I want the ouput in the following format.

but I'm unable to get the entries as in pivot it only shows one data of having only one entry.

Following is my Load statement :

VisitDates:

LOAD [ABM NAME],

     [TBM NAME],

     DOC_NAME,

     Date as DCR_Filed_Date

[madhumitha]

Hi Shuhbam,

Please modify you expression as below.

Concat(Day(DCR_Filed_Date),',')

Thanks!