Eclipse Community Forums: BIRT » SQL: Combine Multiple rows with the same field

Home » Archived » BIRT » SQL: Combine Multiple rows with the same field(I have a table with an order number and a description, the description spans across multiple rows.)

SQL: Combine Multiple rows with the same field [message #1783401]

Mon, 12 March 2018 11:59

Eclipse User

I have a table that has an order# field (KEY) and a description field.
The problem is that i need to combine the description fields, so that there is only one record for all of the description entries and one order#.

Does any one know how this can be done in SQL and works in BIRT.

I have tried group_concat, and a few other things but it looks like none of them are valid in whatever dialect of SQL we are using.

Order# Description
728123 WHITE
728123 35.00X45.00
728123 EXTRA
728123 SANDBLASTED OUTTER
728123 CHARCOAL FLAT
728123 SP
728123 BT
728123 NO GLAZE
728123 EXTRA STICKS
728125 WHITE
728125 56.00X24.00

Another bit of information that may be helpful, is that we are using a DB2 as400 database.

Any help would be greatly appreciated.

Re: SQL: Combine Multiple rows with the same field [message #1786707 is a reply to message #1783401]

Wed, 09 May 2018 12:45

Eclipse User

Try Listagg() function in sql

Previous Topic:	BIRT charts do not work on redhat
Next Topic:	Generating DOC file using BIRT RE API

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Mar 20 08:46:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter