Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Filtering a aggregation: CONCATENATE
Filtering a aggregation: CONCATENATE [message #547318] Fri, 16 July 2010 10:14 Go to next message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
Hello,

I have a data set that I want to have advanced by a computed column.

|CODE|STRING|
|1 |"a" |
|1 |"b" |
|2 |"c" |
|2 |"d" |

That computed column shall contain all stringsfrom the STRING column that match agains a code of the CODE column.
Example:
|CODE|STRING|CONCATENATE|
|1 |"a" |a, b |
|1 |"b" |a, b |
|2 |"c" |c, d |
|2 |"d" |c, d |

I thought using the filter expression of the CONCATENATE function would fit my needs, but I do not know how to test against the current row. My understanding of the function ist, that it is beeing performet for each row once. The filter however I hope is executed also for each row once. So I'm in need of a expression that is able to test against the current row.

For example, if my filter expression is the following I get the strings a and b concatenated.
row[CODES] == "1"

When using code 2 instead of 1, I get the strings c and d.

What filter expression could be used to concatinate all appropiate strings?

Thanks!

Re: Filtering a aggregation: CONCATENATE [message #547942 is a reply to message #547318] Tue, 20 July 2010 08:53 Go to previous message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
I found a possible solution.
When not using a calculated column, but the aggregation tool, it is possible to set up a aggregation to apply on a group. So in my case it was necessary to group the table by code, set up a aggregation using the CONCATENATE function applying to that group and filter duplicate column entries in the table.

Previous Topic:Upgrade BIRT 2.3.2 to BIRT2.6
Next Topic:Text wrapping in Birt
Goto Forum:
  


Current Time: Thu Sep 18 01:41:08 GMT 2014

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

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