4 Replies Latest reply: Jul 7, 2011 1:27 PM by John Witherspoon RSS

    How would I go about combining different fields in this certain way..

      Hi,

       

      I need to create a table for CSV export at the end of the script, and I have fields from different tables that I need to combine, but not just glue the fields together. Here is what I mean:

       

      SomeField | Year  | Month | Number

              1        | 2008 | Jan       | 10

              2        | 2008 | Jan       | 14

              3        | 2008 | Jan       | 12

      ...........

              1        | 2009 | Jan       | 31

              2        | 2009 | Jan       | 24

      .........

       

      I hope you get the pattern.

       

      So my problem is: I need to make sort of a crosstable, where i have the months as fields (so the fields would be: SomeField, Year, Jan, Feb, Mar,...) and the the Number would be a value for a particular month.

       

      I have no idea how to go about forming this table. Any help is appreciated.

       

      Thank you,

       

       

      Siarhei K.