Skip to main content
Solved

Creating new rows based on summary of other data

  • August 8, 2019
  • 1 reply
  • 5 views

Forum|alt.badge.img

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-2018

Job3 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.

View original
Did this help you find an answer to your question?

1 reply

erik_jan
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • August 8, 2019

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings