| Filtering a aggregation: CONCATENATE [message #547318] |
Fri, 16 July 2010 06:14  |
Eclipse User |
|
|
|
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 04:53  |
| Eclipse User |
|
|
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.05623 seconds
Home