Thank you for downloading AIS 1.3 and trying out our Live application. Further I would like to welcome you to our strong users community which includes thousands of users just like yourself from more than 50 countries globally.
Home › Forums › BIRT Reports › Combine multiple row with 1 field
This topic contains 1 reply, has 2 voices, and was last updated by Peter 1 week, 3 days ago.
There is a table with an order# field (KEY) and a description field.
I need to combine the description fields, to make it only one record for all of the description entries and one order#.
can anyone suggest how this can be done in SQL and works in BIRT?
I tried with group_concat and a few others but it none of them worked.
728123 SANDBLASTED OUTTER
728123 CHARCOAL FLAT
728123 NO GLAZE
728123 EXTRA STICKS
I’m using a DB2 as400 database.
Kindly help me out with the solution.
Try with Listagg() function in SQL. You will get it.
You must be logged in to reply to this topic.
Enter your username and password below to login.
Complete the form below to register.
Enter your email address to reset your password.
Active BI Ltd