Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsFiltering a aggregation: CONCATENATE
https://www.eclipse.org/forums/index.php/mv/msg/172051/547318/#msg_547318
I have a data set that I want to have advanced by a computed column.
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!
]]>Jan Kohnert2010-07-16T10:14:14-00:00Re: Filtering a aggregation: CONCATENATE
https://www.eclipse.org/forums/index.php/mv/msg/172051/547942/#msg_547942
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.