The link to last week’s challenge is HERE.
This week’s exercise is another example of how Alteryx can take poorly formatted data such as transactional log files and turn it into usable data.
Use Case: A customer has some data that comes with key product information stored at the top of the file. Each data column contains three lines of header information per product (product, market and type). The customer wants this information to be shown in rows for each product.
Objective: Reformat the input data to match the output example.
My solution slightly different but gives the same results.
A solution has been posted (it looks just like yours @Joe_Mako). Thanks for sharing yours too, @MichelKars.
...and here's another alternative with a hard-coded shortcut. Only works insofar as 1-to-1 relationship between Product, Market and Type remains valid.
Michael, I like the simplicity of your solution. Any chance I could see the .yxmd? I'm at dupton@decisionlab.net. My solution (just posted) also works, but uses hard-coding based on observed values...
I think my solution is the same as some others.
very similar to all the others. Seems that this may be the natural choice (given that so many folk arrived at this independantly)
My solution. Oh, Transpose & Cross-Tab, whatever did I do before I figured out how to use you...
Same solution as many. Split into 2 streams, one for the data, one for the key rows/headers.
Solution:
Happy to see my solutions are starting to look like everyone else's
Solution attached
Here's my very long and clumsy solution! Not sure why but I couldn't get my head around this one.
Spent far too long messing around with those pivots trying all combinations of all the transform tools and finally did it in a fiddly way.... Will refer to how everyone else has done it and get my head around how to pivot data properly!
Solution
Similar solution, though I used Find and Replace instead of Join.
Another one finished! Normally I would have used the TRIM formula, but with version 11.5, the red/ green bar told me what was wrong, so that prompted me to try the Data Cleansing formula instead.
pretty much the same as the solution. Another one down
Several steps to get there - getting great practice with these tools!
This one reminds me of the data I get at work LOL
Solution attached.
My solution is attached.
Struggled with this longer than I'd like to admit, but got there in the end.
Last one for today.
Solution attached - thanks!
Nice simple one
Challenge Completed
I struggled with this one and had to get some ideas from Joe_Mako's approach.
Hi everyone!
Here is my solution:
Hello - I have been following this solution through and I may be doing it wrong but the output in your solution doesn't seem to include the date - is that correct? Any help would be appreciated.
