Skip to main content
Question

Last line entry = 0 for a subfield

  • November 24, 2025
  • 1 reply
  • 26 views
emre
Contributor
Forum|alt.badge.img

Hi, 

I have a report i make where from the data i get out the following (where / separate's attributes)

Field / SubField / YYYYMMDD / ValueX / ValueY

For the last date of the Subfield, i would need a line where Value X and Value Y are zero - the end date is specific to the Subfield. Is there a way to get it to reach - for Subfield - find last date - create +1M from YYYYMMDD with X and Y equal to zero

I know how i would do it in a excel macro, but i dont know how to replicate this in FME 

/Emma

danilo_fme

1 reply

daveatsafe
Safer
Forum|alt.badge.img+20
  • daveatsafeSafer
  • Safer
  • November 24, 2025

Hi ​@emre,

You could try sending the records in a separate stream to a StatisticsCalculator, grouped by Field and SubField, to find the Max of the YYYYMMDD. Use that max value on the Summary output to create the terminating record(s), by incrementing the date and setting the ValueX and ValueY to 0.

Community Stats

32,210
Posts
122,315
Replies
39,897
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.