"Merge" Duplicate Rows or Remove them in Recursive BAQ

[bordway (Bruce Ordway)]

@Anthony_Mattice

“merge” duplicates with commas separating the two results

Have you already seen this?

BAQ: Calculated Field Concatenate Rows to single field

Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and finding all PO numbers for a specific job. The job may have 3 POs. PO Number : Job Number 70001 : 00245 70010 : 00245 70008 : 00245 I want to combine/concatenate these to be something like Job Number : PO Numbers 00245 : 70001,70010,70008