Hi,
I'm trying to create a file which summarises my data, based on monthly counts.
My data:
Job1 Dogs 01-01-2018
Job2 Dogs 14-01-2018Job3 Dogs 22-02-2018 etc..
My summary file is:
Raised Jan-2018 2
Raised Feb-2018 1 etc..
And I want to be able to run it for this month, and it append on the end "Raised Aug-2018 22" based on the count of this month.
Best answer by erik_jan
First you want to create a month attribute from the data by using the DateTimeConverter transformer.
Next you need the StatisticsCalculator (using the count statistic) to create the number per month (group by the month).
Finally you want to create your output line by using an AttributeCreator transformer, concatenating in the Text Editor the text Raised, the month and the count.
Hope this helps.
+19First you want to create a month attribute from the data by using the DateTimeConverter transformer.
Next you need the StatisticsCalculator (using the count statistic) to create the number per month (group by the month).
Finally you want to create your output line by using an AttributeCreator transformer, concatenating in the Text Editor the text Raised, the month and the count.
Hope this helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
