David JonesSEMARCHY TEAM
Technical Client Success Manager at Semarchy

Scenario: In a form with a lookup SemQL expression, the business need is to have each returned Product displayed on a separate line. Currently, Products are separated by a comma and share a single line.

Solution:  Between single quotes, add 2 spaces and the Enter/Return key.

Example:

Original SemQL, using comma as separator.

LOOKUP string_agg FDN_Product separated by ', ' from PersonProducts order by FDN_Product END

 

Original Result

Image 1: Illustration depicts products on a single line separated by comma. 

Modified SemQL using 2 empty spaces + Return/Enter for a line return.

LOOKUP string_agg FDN_Product separated by '  ' from PersonProducts order by FDN_Product END

 

Updated Result

Image 2: Illustration depicts products on separate lines.