We posted the solution JSON file to Cloud Quest 9. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
For this week's quest, you received product data that was, shall we say... interestingly formatted in Excel 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). To make downstream analysis possible, reformat this information to be shown in rows for each product.
Hint: If you are used to the configuration terminology of the Transpose tool in Designer Desktop:
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
Once you have completed your quest, go back to your Analytics Cloud library.
Thanks @AkimasaKajitani: this helps.
Of note: the formula should be used as REGEX_Match(String, pattern, icase) and does not allow reversal of String and pattern arguments it seems.
I sometimes over-think them!!!
Well, in attempting to create an app in App Builder for extra credit, this helped me uncover a potential defect in App Builder. Win Win!
This one took me a minute to get started but once I got started, I was able to find a fairly simple solution: