The solution to last week's challenge can be found here!
This week's challenge was submitted by the illustrious @MarqueeCrew who came across this challenge at a Tableau User Group! Yes - the problem really was around beer and Pop-Tart pairings.
At a recent Tableau User Group, a poll was conducted using SurveyMonkey and the data was exported to an Excel workbook. Unfortunately, the data wasn't in a format that made it easy to work with in Tableau. Fortunately, an Alteryx user was there to prep the data on their behalf.
Within the survey data, there are repeating groups of Pop-Tart, Beer and Score values. Yes, the TUG had samples of Pop-Tarts paired with the beers from Bell's Brewery. The task was to create a single column for each of these values, allowing for repeating the balance of the survey results.
Can you Normalize the output data? For bonus play, can you analyze the data and provide insights from the sample data?
The output should include:
1. Name of the fiber
2. The original spatial line object
3. The new spatial line object
4. New length of line
Can't say I have ever paired beer and poptarts together before! Solution is attached.
I handled the pairings with the dedicated columns through transpose and then splitting the column name using a simple replace formula, then split them out with the text to columns. then for the special pairings I used the arrange tool to create the 3 fields. then union the data together.
seems to work pretty well.
Went down a rabbit hole by using the Field Info tool, selecting column with a Formula, then trying to dynamically pull data from the desired columns. But when I tried the Dynamic Select tool things fell into place pretty quickly. I had never used the Dynamic Select tool before, so this has been a fruitful exercise.
This can handle the additions or deletions of columns.