aggregator to sum up the values on month wise

sangvi · Post by **sangvi** » Fri Mar 11, 2005 1:15 am

Hi,
Help me out in summing up certain values from a file by the month wise .Out of three columns in my file one is date column.

Regards,
Sangvi

sangvi · Post by **sangvi** » Fri Mar 11, 2005 1:41 am

Hi
I had a step working for this just wanted to verify will that be fine.Called the date field from file into the transformer with DateGenericGetMonth function and then use aggregator to group the field and got the result wanted.

Regards,
Sangvi

T42 · Post by **T42** » Fri Mar 11, 2005 4:12 pm

If you want to count the months, you can get MonthFromDate(). If you want to count the days... MonthDayFromDate(). There are a number of options you can use -- just look at Appendix B ("Functions") on your Parjdev.pdf file.