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.
+15you 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.
That worked! Thank you so much!! I knew it had to be doable in FME.
Thanks,
Dale
+18That worked! Thank you so much!! I knew it had to be doable in FME.
Thanks,
Dale
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
