2023: Week 44 - Solution

Solution by Tom Prowse and you can download the workflow here.

Step 1 - Missing Dates

First we want to input the Events table and then utilise the New Rows steps to fill in the missing dates between the first day of term and last day of term.

The new rows step is setup with using the Date field between the min/max dates with an increment of 1 day:

After the new rows have been created we want to find the weekday for each of the dates so we can duplicate the date field and then convert the duplicate to day of week

Then we can filter to remove the weekend days (Saturday & Sunday). The table should now look like this: 

Step 2 - After School Clubs

Now we can include the After School Clubs data source and join with our existing workflow using the day of the week fields on both sides.

Finally we can replace the null values in the Event field with N/A by double clicking on the profile pane and typing 'N/A'.

Our final output looks like this:

You can download the output from here.

After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @Datajedininja, @JennyMartinDS14 & @TomProwse1

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help!