You have CSV files that look something like this:

Test, Result, Case, Type
------------------------
t1  , pass  , c1  , Functional
t2  , fail  , c1  , Operational
t3  , fail  , c2  , Functional
t4  , fail  , c2  , Operational

For example, You want to get a single-column list of the unique values of the ‘Type’ column:

Type
--------
Functional
Operational

or a summary of each type:

Type         TypeNum
--------     ----------
Functional   2
Operational  2

If you were hitting a database, you could use some SQL like

SELECT DISTINCT type
FROM thatFile

or

SELECT  Type, sum(*) as TypeNum
FROM thatFile

It seems in BIRT that it doesn’t have that luxury.

But you are able to query the data in the CSV files with esProc using SQL.

Here is the esProc SPL script:

The report can be designed in the same way as you would if you were retrieving the data from a database. For detail SPL integration with BIRT, see How to Call an SPL Script in BIRT.

For many difficult calculations of Text Computing, you can refer to Structured Text Computing.

If you have any questions or comments, please leave them below.