Page 1 of 1
aggregator to sum up the values on month wise
Posted: Fri Mar 11, 2005 1:15 am
by sangvi
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
Posted: Fri Mar 11, 2005 1:41 am
by sangvi
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
Posted: Fri Mar 11, 2005 4:12 pm
by T42
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.