nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Generating addtional date using Multi row tool

Wafarian

Hi,

I have a requirement to generate missing date using Multi-row tool in Alteryx but it is not working as planned.

below is my requirement and I would like to generate additional date which is 29th that is missing from posting date

I have implemented below logic but it is now working.

Multi-row generation_logic.PNG

much help will be appreciated in resolving it.

thanks,

Community

Accepted answers

DataNath

Hey @Wafarian, to fill in missing dates/records, you'll need the Generate Rows tool. In setting this up, we tell Alteryx to generate rows (in this case, by adding a day to the date) until a certain condition is reached (being within 1 day of the next record's posting date). In order to get the next record's posting date in the first place, we can use the Multi-Row Formula to look ahead one row and bring this in. Throughout all of this, as your date is in DD.MM.YYYY format, we just add some extra expressions to parse this into ISO format (YYYY-MM-DD), as this is the only date format Alteryx can work with. The Formula/Select tools at the end are simply to get the generated date back into your original format - which I have assumed is the desired display - and remove temporary fields used to generate the additional rows. I've attached the workflow below but please feel free to ask us if you have any confusion or further questions!