Generating Rows based on a certain number

Hi Everyone,

I'm super new to the world of Alteryx and all it can do, I have a problem I'm stuck with that I hope maybe some you experts could help me with.

Essentially what I'm trying to do is generate rows for each person based on the number of days they are away on holidays I have attached a small piece of the workflow with bit of the data I'm using as a sample. I can't wrap my head around how something liked this could be done

Any help with this matter is greatly appreciated thanks in advance everyone.

Testing.yxmd

Workflow

Accepted answers

DataNath

Hey @DataIsFun, does something like this look right? We're adding the generated row number (-1 to compensate for not being 0-based) to the date and then formatting the date as the day of the week it corresponds to:

Generate rows and populate weekday.yxmd

All comments

DataNath

Hey @DataIsFun, you can do something like the following. This just tells Alteryx to generate rows, starting at one until it reaches N, with N being your [Days_Between_Leave_and_Return] value.

Testing.yxmd

davidskaife

Hi @DataIsFun

something simple like this will work, you generate the number of rows based on the days difference you've already calculated:

The setup of the Generate Rows tool is below:

Testing.yxmd

DataIsFun

Thank you guys so much for the rapid response I see exactly what you both did there I was just wondering instead of having just numbers in the new rows is it possible to have the day of the week instead?

DataNath

Generate rows and populate weekday.yxmd

DataIsFun

Hey DataNath sorry I don't know how to @ people on here just yet but ill give it a try now the full workflow and see if all goes well if not i'll let you know and again thank you for the help

DataNath

No problem @DataIsFun! The @ functionality becomes available at the next community level (6 - Meteoroid)! https://community.alteryx.com/t5/Alteryx-Community-Resources/FAQs-User-Ranks/ta-p/178548

DataIsFun

Hey again DataNath this worked like a charm thank you for the help

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703