Skip to main content
Solved

Adding 3 consecutive records

  • February 21, 2018
  • 4 replies
  • 27 views
T

Hi,

We 100+ years of rainfall data that we would like to find 3 consecutive days where the rainfall is greater than 50mm after a certain date. I can do this in Excel but I can't for the life of my figure out how to do it in FME. Does anyone know if it is possible?

In excel adding three consectutive days rainfall is pretty simple =SUM(F2:F4) and fill down the column.

Cheers,

Dale

Best answer by david_r

You can use the AttributeCreator with the adjacent feature option, e.g.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • February 21, 2018

You can use the AttributeCreator with the adjacent feature option, e.g.

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • February 21, 2018

you can also partition the data by creating an attribute conditionaly >50mm = yes

Then a counter on that attribute. Statistics grouped by that and get max value.

Test if >3

T
  • toasthall
  • Author
  • February 21, 2018

You can use the AttributeCreator with the adjacent feature option, e.g.

Hi David,

 

That worked! Thank you so much!! I knew it had to be doable in FME.

 

 

Thanks,

 

 

Dale

 

 

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • February 23, 2018
Hi David,

 

That worked! Thank you so much!! I knew it had to be doable in FME.

 

 

Thanks,

 

 

Dale

 

 

PS: I like your name! Not too many of us around, let alone in the FME community!

 

 

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.