I have a data file that has 3 fields, a date, a node and a count. I
would like to build a matrix (table) with date across the top as column
titles, nodes down the left column as row titles and counts filling the
cells. The real data file has an unknown number of nodes but only 7
dates. I can build this in Rexx but would like to see if Pipelines can
streamline the processing. Can someone point me at something?
/Tom Kern
Here is what the data would look like:
01/21/09 NODE-A count1
01/21/09 NODE-B count2
01/21/09 NODE-C count3
01/22/09 NODE-A count4
01/22/09 NODE-B count5
01/22/09 NODE-C count6
This is what I would like the output to look like:
01/21/09 01/22/09
NODE-A count1 count4
NODE-B count2 count5
NODE-C count3 count6
