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 · Accepted solution]

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!

[anovohatski1]

Thank you. How would i manipulate Generate Rows Tool further to get something like this?

Mon.            Al.   8.     7/6/2020

Thursday.    Al.   3.     7/9/2020

Friday.         Al.   7.     7/10/2020

Saturday.    Al.   7.     7/11/2020

Sunday.      Al.   7      7/12/2020

Currently I get an output that looks like this:

Mon.            Al.   8.     7/6/2020

Thursday.    Al.   3.     7/9/2020

Friday.         Al.   7.     7/10/2020

Saturday.    Al.   7.     7/10/2020

Sunday.      Al.   7      7/10/2020

Please note that I do have date values in my dataset.