tindavid

asked on

# perl to display a matrix report for 3-dimenional array

Hi All,

@arrayTime = [time1, time2, time3, ......] where time value has format like 20150710 10:24:10

@arrayID = [ id1, id2, id3, id4, ....... id15]

@arrayPrice = [ Value1, Value2, Value3 ..... Value15]

I will like to produce a Matrix Report like below

id1 id2 id3 ....... id15

time1 value11 value21 vaue31 value151

time2 value21 value22 ....

time3

Thanks

David

@arrayTime = [time1, time2, time3, ......] where time value has format like 20150710 10:24:10

@arrayID = [ id1, id2, id3, id4, ....... id15]

@arrayPrice = [ Value1, Value2, Value3 ..... Value15]

I will like to produce a Matrix Report like below

id1 id2 id3 ....... id15

time1 value11 value21 vaue31 value151

time2 value21 value22 ....

time3

Thanks

David

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

greate!

You show @arrayPrice as having 15 values which your desired output shows as enough values to populate only one time row. Where are the other values coming from?

In order to relate a value to a time and id, there must be some way to relate them. Since @arrayID and @arrayPrice both have 15 values, I'm assuming the ordering of values matches the ordering of ids - is that correct? How do you know which time the values relate to?