Groovy in Integrator
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!
- 7 Forums
- 21 Topics
- 53 Posts
- 0 Online
- 93 Members
Join the Jedox4Beginners forum and engage with a community of passionate Jedox users. Get expert advice, share insights, and find solutions to your Jedox-related queries. Unlock the power of collaboration and accelerate your learning journey in the world of Jedox.