Skip to main content
  • EN

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

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

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

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

 

 

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!

 

 

Reply


Community Stats

30,108
Posts
114,282
Replies
37,742
Members
Terms & ConditionsCookie settings
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.