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

Topic		Replies	Views
BAQ Calculated Fields Yahoo Archive	9	1859	March 21, 2011
Concatenate/Combine for a Calculated Field Yahoo Archive	5	1339	December 6, 2007
BAQ Concatenate fields Yahoo Archive	3	1727	September 12, 2013
Leading Zero BAQ Calculated Field Kinetic ERP baq-calculated-field	20	2028	December 21, 2022
SSRS Report Help Epicor ERP 10 ssrs , reports	40	1359	February 22, 2024