Combine Calculated felds into one row via BAQ's

Hi,

I have the below:

I am tryaing to have the Quantity Break Concat field as one row separated by a comma and i am struggling with it as i cannot use a SubQuery to CAST the calculated field as it shows more than one result.

What you really need is unpivot (not available in BAQ as far as I’m aware), but you can achieve similar with a few subqueries and union all the results. There may be a better way, especially since you don’t know how many concatenated values there will be.

@Ricky90 I think this is covered in this post. I would probably just make it an updatable baq and do a foreach in getlist post processing to combine them, but I am lazy.

1 Like

string_agg