Row Generator - Add Rows for Missing Dates within a Range
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx Community,
I am trying to leverage the "Generate Rows" tool to add (missing) dates to my data set. The goal is to have a row for every single day that falls within the min/max date range of a given project ID. The visual will make it easier-
Data Input:
Desired Data Output (the grey rows are the rows I would like to have added):
Thank you,
Felix
Solved! Go to Solution.
- Labels:
- Help
- Output
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My go at a solution for you. I also used the MultiRow formula tool, like @brindhan. Just simplified the formula a bit. You can use <, >, and = when comparing dates in Alteryx.
My formula:
IF [DateTime_Out]<=[Row+1:DateTime_Out] THEN [Row+1:DateTime_Out]
ELSE [DateTime_Out] endif
Also included a few tools to return the date to the original text format if desired.
Cheers!
Esther
