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?