I am trying to concatenate multiple rows to a single field in a query and am wondering how to do it in a BAQ. Below are a couple of different ways I can do it in a SQL query. Example 1: Select distinct ST2.JobNum, substring( ( Select ‘,’+ ST1.OpCode AS [text()] From Erp.JobOper ST1 Where ST…

BAQ Concatenate Rows Columns to Field

Banderson (Brandon Anderson) April 27, 2018, 2:49pm 2

Check out this thread. There is an example BAQ that you can download to show you how it works.

1 Like