Hello, I face a problem during a field transform in Jedox Integrator:

I have an extract which contains one column with different values. Some values double and I want to get the count of the doubled values in a extra column. Column Aggregation does not work, as in my case it just counts 1,2,3,4 and so on. Now I was trying to code that in groovy. But the implementation in Jedox is very different than usual groovy coding. Can you please help me to set that count?

Example:

column1

2000

2000

3000

4000

4000

4000

output:

column1    column2

2000         2

2000         2

3000         1

4000         3

4000         3

4000         3

Thanks in advance!