Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 15:59 Go to next message
Tyler Gillette is currently offline Tyler GilletteFriend
Messages: 1
Registered: March 2018
Location: Clovis, Ca
Junior Member
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 SP
728123 BT
728123 NO GLAZE
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 16:45 Go to previous message
geetha aara is currently offline geetha aaraFriend
Messages: 2
Registered: May 2018
Junior Member
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:

Current Time: Sun Apr 21 02:50:28 GMT 2019

Powered by FUDForum. Page generated in 0.03334 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top