<p>Greeting to all,</p>
<p>I am using BIRT 4.5 bundled with Eclipse.</p>
<p>One of the data sets I am working on is a csv file with 500 or so columns.</p>
<p>Data fields in these columns are mostly numerical.</p>
<p>I have a requirement to add a number of computed columns.</p>
<p>The field values of these columns will be the sum of some of the fields of original 500 columns on the same row.</p>
<p>I tried using the Expression Builder but that takes a long time to do and error prone.</p>
<p>Is there a way to write a script or other APIs where these computed columns fields expressions can be defined? For example:</p>
<p>- ComputedCol-1 = Sum (col1 to col 20).</p>
<p>- ComputedCol-2 = Sum (col21, col27, col30).</p>
<p> </p>
<p>And so on.</p>
<p> </p>
<p>Thx and BR</p>
