Compare 2 data set

Hi,
I'm really new on BIRT and trying to create a couple of reports from a IBM DB2 database.
I have 2 questions but I will put them on different thread so I can easy keep my answer separated.

This question is really hard to explain but I will try as best I can.
I have 2 data source that one is based on CSV format and the other one will come from a DB2 Table.
From each dataset will I get a lot of information that is depending on each other.

Let's call them DATASET1, DATASET2

In DATASET1 does I have following information
TYPE , CORES , POINTS
A , 1 , 100
B , 1 , 50
C , 1 , 70

In DATASET2 Does I have following Information
TYPE , CPU , CORES
A , 2 , 1
A , 4 , 1
B , 2 , 2
C , 2 , 3
B , 4 , 2

What I want to do is compare the TYPE in both dataset and then take DATASET2.CPU x DATASET2.CORES x DATASET1.POINTS and want following result

TYPE , CPU , CORES , POINTS
A , 2 , 1 , 100
A , 4 , 1 , 400
B , 2 , 2 , 200
C , 2 , 3 , 420
B , 4 , 2 , 400

I hope you understand what I'm looking for.

Thanks for your help
Christian Svensson

Find more posts tagged with

Comments

mwilliams

Hi Christian,

If I understand your question completely, you should be able to make a joint dataSet, joining on TYPE. Then, create a computed column for the field you need to be figured from both dataSets in the new joint dataSet.

Hope this helps.

Issen

Hi,
Both yes and no.
What I'm looking for is to have a matrix how many points A, B or C is worth.
Then take that point and do a mathematic calculation.
(CPU x CORES) x POINTS

Thanks
Christian

mwilliams

Christian,

This solution would allow you to achieve that result. It just wouldn't go to a lookup table each time. The "points" value would be a part of the row in question. You could do the calculation straight across on each line.