Populating Weekend Data based on Friday

anovohatski1

Good morning,

I am new to Alteryx, so my apologies if the question has been asked before. What's the best way to populate weekend data based on Friday's input? Would Generate Rows tool be my best option?

Here is an example:

Day of the week | Name | Amount

Thursday              Al            5

Friday                   Bob         2 

Friday                   Al.           7 

Monday                Sarah      3

Trying to achieve:

Day of the week | Name | Amount

Thursday              Al            5

Friday                   Bob         2 

Friday                   Al.           7 

Sat                        Bob.        2

Sat                        Al.          7

Sun                       Bob.       2

Sun                       Al.           7

Monday                Sarah      3

echuong1

There are multiple ways of doing this, and you're on the right track with generate rows.

I've created a quick example. See attached. This would also be more accurate if you had actual date values, as you could order them in the case there are multiple instances of a day of the week.

Hope this helps!

New Workflow1.yxmd