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"?
Date
Votes
1 comment
-
Jet Central 365 Create a custom field and then perform a custom transformation to have a field than contained your single value then create a conditional lookup/
Jet Central 365
Your Jet Reports & Jet Analytics Partner.
For all your Jet Reports & Jet Analytics consulting services : sales@jetcentral365.com
Please sign in to leave a comment.