Home Forums BIRT Reports Combine multiple row with 1 field

This topic contains 1 reply, has 2 voices, and was last updated by  Peter 4 months, 1 week 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.