Concatenating multiple records (similar to MySQL group_concat or SQL string_agg)

Is there any way in the Jet Data Manager to carry out the equivalent of a string_agg/group_concat function on the values returned by a conditional lookup? In other words, is it possible to aggregate multiple records that are returned by the lookup into a delimited list? For example, if a lookup could return two values "One" and "Two" based on whether "minimum" or "maximum" is chosen as the operator on the lookup field, is there a way to combine them into a single value "One, Two"?

1 comment

Please sign in to leave a comment.