community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

bryanmac_92
8 - Asteroid
a week ago

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 Through
Spring 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/2025
Spring 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/2025
Spring 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 Through
Spring 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/2025
Spring 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/2025
Spring 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. 

 

 

 

Reply
0 Likes
1 REPLY 1
gawa
16 - Nebula
16 - Nebula
a week ago

@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. 

 

image.png

1379150_gawa.yxmd
Reply
0 Likes
inspire session catalog
view community live events
Labels
Top Solution Authors
View All