Fill Down or Repeat field through join

[flipperdm]

Hi,

I'm having difficulty finding anything even close to my desired solution to this through the discussions so I'll try a new topic.

I have a table contains a "week number" field, indicating when a fruit is first put into a zone

I need to fill the missing weeks that occur between the zone changes, but not to exceed the earliest week number but can go as high as I limit (in this case, week 20).  This would repeat the zone until it changes.  What tool or logic would I use to create this data?

[geraldo · Accepted solution]

Hi,

A very quick suggestion might be this
Use the Generate rows tool and formula tool

follow the setting

[]

[flipperdm]

Perfect.  I can also add a filter to eliminate any weeks that are over 52.  Thank you much!