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