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 :…

BAQ: Calculated Field Concatenate Rows to single field

josecgomez (Jose C Gomez) May 31, 2017, 7:48pm 2

You can use one of these methods to do it I’ve done it with the XML method in E10

2 Likes

BAQ Grouping Records into one field

Concatenate multiple rows into one row, with criteria

BAQ Concatenate Rows Columns to Field

BAQ - Concatenate results from subquery into one field

BAQ's in E10 using multiple views (CTE's & Recursive CTE's)

PO Lines replicating in the BAQ

Customer Attributes List