Custom Text

Home » Topic » Combine multiple row with 1 field

Combine multiple row with 1 field

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.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #418

    vinaysaraswat
    Participant

    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.

    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

    I’m using a DB2 as400 database.

    Kindly help me out with the solution.

    Thanks,
    Vinay

    #419

    Peter
    Participant

    Hello Vinay,

    Try with Listagg() function in SQL. You will get it.

    Thanks,
    Peter

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.