Listing multiple hires in a single cell
I'm using the below formula to list all of the hires in a single cell, however when I try to clean up the output using either TRIM or REPLACE I receive a SQLExecDirectW error. Is there a better way to incorporate the CASE logic?
(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),CASE "Submission Job Offer"."Status" WHEN 'Accepted' THEN "Candidate Identification"."First Name"||' '||"Candidate Identification"."Last Name" END,'<br>'))