|Filtering a aggregation: CONCATENATE [message #547318]
||Fri, 16 July 2010 06:14
| Jan Kohnert
Registered: July 2009
I have a data set that I want to have advanced by a computed column.
|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.
|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?
Powered by FUDForum
. Page generated in 0.05328 seconds