Alteryx Academy

Hello Community Members!   A solution to last week’s challenge can be found here.    This challenge was submitted by our valued ACE, Yughandar Muley. Thank you, @ydmuley for this excellent contribution!   The holiday season is just around the corner, and it is the most magical time for businesses to thrive—and for seasonal employees to earn some extra money!   Meet Tom, a student who is looking to make some holiday cash. His family runs a homemade cookie business, and they need someone to pack orders during the bustling season.   Tom works 6 days a week and is paid $15 per hour, working 4 hours a day on weekdays, and 10 hours a day on weekends. He has Thursdays and holidays off, including Christmas on December 25th and New Year’s Day on January 1st.   Your challenge: Calculate Tom’s earnings for weekdays, weekends, and his total pay for the contract period! His start and end dates are provided in a Text Input tool in the workflow.   Let’s spread some holiday joy and solve this festive challenge!   Need a refresher? Review the following lessons in Academy to gear up: Diving Into Expressions Changing Data Layouts   Have a wonderful holiday season!   The Academy Team ... View more

A solution to last week’s challenge can be found here.  To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.    If you are currently selling your home, you may not be happy to learn that capital gains (profit from the sale of the home) are taxable in the United States. One way to reduce the amount of capital gains taxes you pay is to use deductions.     For this challenge, we will use two possible deductions, the Exclusion of Gain (you may qualify to exclude up to $250,000 of the capital gain from your income as a single filer, or up to $500,000 of that gain if you file a joint return with your spouse); and Capital Improvements (when home sale profits exceed the exclusion of gain threshold, consider deducting any capital improvements you made to the home while you owned it).    Your challenge is to answer two questions:  Identify which home sellers will have to pay taxes on the profit made from the sale of their home.  Determine how much those sellers have to pay.  Use the information below to calculate and determine who should pay taxes.  Source: https://www.homelight.com/blog/tax-write-offs-for-sellers/#:~:text=Page%209%20of%20IRS%20Publication,retaining%20wall%20or%20swimming%20pool  DISCLAIMER: This challenge is meant for educational purposes only and is not intended to be construed as financial, tax, or legal advice.  ... View more

Hi Community,   We posted the solution JSON file to Cloud Quest #23. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!     Let’s dive into this week's quest!   Download the provided JSON file containing your starting data and workflow files. Upload the provided Cloud Quest #24 Start.json file into your Analytics Cloud library. All necessary datasets are contained within Text Input tools in the workflow.     For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.     Scenario:   This week’s quest is all about creating a workflow that can adapt to different incoming data schemas. The starting datasets contain strings of letters that can be parsed into words of different lengths based on various character starting positions within the string. Create a process that automatically parses the data from Dataset A using the parsing instructions provided. Once you create the workflow, you should be able to replicate your process for Dataset B by copying and pasting your tools.   Hint: If you are stuck, start with an Append Columns tool. A combination of the Cross Tab, Formula, Select, and Append Columns tools should solve your problem, but not necessarily in this sequence. If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Alteryx Academy for guidance: Getting Started with Designer Cloud Building Connections in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file. Include your JSON file as an attachment to your comment.   Here’s to a successful quest!             Download Start File ... View more

Hi Community,   We posted the solution JSON file to Cloud Quest 21. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!   Let’s dive into this week's quest!   Download the provided JSON file containing your starting data and workflow files. Upload the provided Cloud Quest 22 Start.json file into your Analytics Cloud library. All necessary datasets are contained within Text Input tools in the workflow.   For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.    Scenario:   We are officially in the holiday season here in the US! In honor of this celebratory time, let’s discover some unofficialholidays listed on nationaldaycalendar.com.   For this week’s quest, your task is to create a two-column table with all these holidays in chronological order.   Hint:  The DateTime tool will parse string dates with a warning if the format is inconsistent.   Useful DateTime Specifiers: %d = Day number %B = Month %b = Mon   A combination of the Formula, DateTime, Sort, Select, and Transpose tools should solve your problem, but not necessarily in this sequence.   If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Alteryx Academy for guidance: Getting Started with Designer Cloud Building Connections in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file. Include your JSON file as an attachment to your comment.   Here’s to a successful quest!     ... View more

Hi Maveryx,   Welcome to your very first Cloud Quest! This initiative is a thrilling journey into the world of the Alteryx Analytics Cloud, and we are kicking things off with a focus on Alteryx Designer Cloud. These new quests are not only tests of your skills but also opportunities to delve deeper into the practical uses of Designer Cloud in handling real-world data issues.   In the world of data processing, text files often include quotes, which are commonly used to manage strings. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple character types.   In this quest, you have a CSV file containing two rows of concatenated data that include double quotes, single quotes, and commas, which enclose different data types. Use Designer Cloud to separate the data into three different columns: Poem, Poem ID, and Poem Read Date. Refer to the image below to see how your solution should look.       Hint: A combination of Formula, Text to Columns, and Select tools should be suffice to solve your problem! If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connection in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.   Here’s to a successful quest!   SOLUTION   ... View more