The link to last week’s challenge (challenge #22) is HERE.
Restructuring poorly formatted data is one of the most common Alteryx use cases. For this challenge we will attempt to straighten out some Very poorly formatted data that is representative of an actual customer request.
The use case: A CPG company is having difficulty managing its data for analytics. The data they receive via an excel spreadsheet contains empty rows and misaligned fields.
The objective: reformat the data in order to enable the analytics team to spend less time staging the data and more time doing analytics.
Update: As of 9/26/19, the start and solution file to this challenge have been updated. Your solution will not match those posted by our Community members prior to this date.
Posting my version of the solution now behind the spoiler tag. I used a tool out of the preparation group as well as a string function that I had not used before to come up with my solution. Both came in quite handy! I went the extra step to convert strings to numbers since I noticed $ in unit fields. Thus the client now has the correct values for the unit type ( $ vs units).
Congratulations to @NicoleJohnson to be the second ever person to hit the 50 challenges completed badge!
It's going to be a race to the finish line to see who will be first to hit the final 75 challenges badge (the mythical Bergschrund Crevasse badge)
So - it's still all to play for - 65 challenges out there so far, and @JoeM is probably cooking up number 66 & 67 as we speak!
Thank you @SeanAdams!! I'm SO excited about all the cool tricks I've picked up doing these challenges so far. And it's even more fun challenging myself to keep up with someone, so keep crushing those challenges and I will see you (and hopefully a few others) at the top! :)
I'm sure I made this a lot more complicated than i needed to be but looking at other solutions mine seems pretty simple!
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.