Hi all,
I've been trying for a while to generate some rows for missing Saturdays and Sundays in my dataset with no luck essentially I have dates like so:
Input:
Leave Date | Day |
05/02/2024 | Monday |
06/02/2024 | Tuesday |
07/02/2024 | Wednesday |
08/02/2024 | Thursday |
09/02/2024 | Friday |
12/02/2024 | Monday |
13/02/2024 | Tuesday |
14/02/2024 | Wednesday |
15/02/2024 | Thursday |
16/02/2024 | Friday |
And I need to achieve an output like so where my data will have the missing rows for Saturdays and Sundays.
Output Needed:
Leave Dates | Day |
05/02/2024 | Monday |
06/02/2024 | Tuesday |
07/02/2024 | Wednesday |
08/02/2024 | Thursday |
09/02/2024 | Friday |
10/02/2024 | Saturday |
11/02/2024 | Sunday |
12/02/2024 | Monday |
13/02/2024 | Tuesday |
14/02/2024 | Wednesday |
15/02/2024 | Thursday |
16/02/2024 | Friday |
17/02/2024 | Saturday |
18/02/2024 | Sunday |
Many thanks in advance folks for any help
Solved! Go to Solution.
You might want to look at the TS Filler! Then you can format as you need afterwards: TS Filler Tool (alteryx.com)
@Deano478 One way of doing this
@binuacs That worked like a charm, I made small tweak before outputting and found what I was looking for many thanks