Skip to main content

Hello everyone

How can I restart a row counter in FME at the beginning of each year?

I have a dataset with a year attribute (e.g., 2025, 2026). I want to generate a rowid that starts at 1 for each new year and increments sequentially.

Example:

  • For 2025 → rowid should be 1, 2, 3 …

  • For 2026 → rowid should reset back to 1, 2, 3 …

I then want to concatenate the last two digits of the year with the padded rowid to create a WorkOrderID like:

  • 250001, 250002 …

  • 260001, 260002 …

Which FME transformers or workflow should I use to reset the counter per year?

You can do this with a counter, just set the Count Domain to the attribute containing the year

Then something like this to create your work order id

 

Hi ​@ebygomm , thank you so much, it worked.

Community Stats

32,030
Posts
121,648
Replies
39,655
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.