Edit column values in table with script

Hey guys!

This could sound like an easy to answer question, but I am new to scripting with BIRT so don't mind

I have a column called URI, and every value in it has to be unique. So, I need to fetch the whole column, cound how many one value appears in the column, add ("." + how_many_times_apeears) to that value, and return the column into the report with updated values.

Demonstration. My current situations looks like:

col1 col2
A 10
B 20
A 10
A 10

My result has to look like this:

col1 col2
A.1 10
B 20
A.2 10
A.3 10

I tried with the DataSet onFetch event, but it turns out I can't use scripting on joined datasets.

Any help?

Thanks!

Find more posts tagged with

Comments

Hans_vd

Hi Nanneia,

You could add a grouping to the table and create a runningcount aggregation (that you can hide using the visibility property). Use the expression builder to add the "." and the result of the runningcount to col1

When doing it this way, you can't keep the ordering as it is in your example though.

Hope this helps
Hans

nanneia

Thank you Hans for your reply!
I have found another way not to get it like explained, but still my URI column values are all unique now.

I will however try if this works too!
Thank you once again