2022: Week 46 - Solution
Solution by Tom Prowse and you can download the workflow here.
The challenge this week is to relook at last week's workflow and update it so that it works for multiple regions. For the challenge we have been given multiple inputs so we need to make the workflow dynamic so we can include different regions.
Step 1 - Update Input
First we want to update the input so that it is the new file containing the 4 different regions. Currently, we only have London, so we can edit the connection and then choose the new file.
We should now have 4 tables - London, Northern, Scotland, and Wales.
To include the multiple sheets we can use a wildcard union within the output to include all 4 sheets
This might look slightly different depending on what version of Tableau Prep you are using.
Finally we can rename Table Names to Region and then remove the File Paths field.
Step 2 - Update Workflow
We now need to make a couple of changes to the workflow in order to make sure that we don't have any duplication.
First, we need to ensure that we include Region = Region into join the conditions:
Join Months
Join Headers
We will also then need to remove the duplicated Region-1 field after each join.
Once we have made these updates we're ready to output our data! Some nice easy changes to make our workflow dynamic for other regions.
You can download the full output 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!
