Filtering a aggregation: CONCATENATE [message #547318] |
Fri, 16 July 2010 10:14 |
Jan Kohnert Messages: 196 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!
|
|
|
|
Powered by
FUDForum. Page generated in 0.03255 seconds