How to use the generate rows tool to add in missing date values?

Question

Hello!

I am trying to see how to use the generate rows tool to add extra rows to my data but not sure on how to do so.

Here is a subset of my data:

Academic CalendarSession NameSessionAcademic YearFiscal YearFiscal Year RangeStart Date2Start DateEnd DateEnd Date2ModelWeeks OutWeeks Out DateData ThroughSpring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's03/3/20253/2/2025Spring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's12/24/20252/23/2025Spring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's22/17/20252/16/2025

As you see above, in the Weeks Out Date column, there are days in between each row that are missing. ie. days between 2/24/2025 and 3/3/2025.

This is an example of what I mean where the data between each of the weeks out date is filled in.

Academic CalendarSession NameSessionAcademic YearFiscal YearFiscal Year RangeStart Date2Start DateEnd DateEnd Date2ModelWeeks OutWeeks Out DateData ThroughSpring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's1 2/24/20253/2/2025Spring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's1 2/25/20253/2/2025Spring Session II – 2025 – March 3, 2025 – April 27, 2025Spring Session II20252520252025FY24-253-Mar-253/3/202527-Apr-254/27/2025last 3 5's1 2/26/20253/2/2025

and so on.

Gawa · Answer

@bryanmac_92 Here is how to use the Generate Rows tool for padding the missing days.

The Generate Rows tool cannot refer to previous/next record unlike the Multi Row Formula tool. In order to properly set the Condition Expression, it's essential to put another column. In my WF, I created a column 'limit' for that purpose.

As a general caution, if Condition Expression already returns 'False' at first loop, those rows will be gone from output of the Generate Rows tool. To keep the original record for sure, Condition Expression shall be properly set so that Condition Expression returns 'True' at first loop.

The Generate Row tool is tricky but very powerful and unique tool that cannot be directly replaced by any other tools.

1379150_gawa.yxmd