Alteryx Academy

For the fourth challenge let’s look at parsing Dates from text strings. To view the previous challenge, click HERE.   A dataset contains a text field that has a date embedded within the text. The problem is that the date is represented a few different ways. For example:   16-APR-2005 Nov•16,•1900 4-SEP-00 Jan•5•2000   The goal is to create a new Date/Time field populated with the dates contained within the text field. You will also need to standardize the dates so that they are all formatted the same. We have listed this as an advanced exercise since parsing out the dates can be challenging depending on the technique you employ to do it. As always, we love to hear your comments. Have fun!   UPDATE 12/7/2015: The solution has been uploaded ... View more

We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.   Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.   Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.   You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance.    Update 11/23/2015: The solution has been uploaded. ... View more

Hi Community,   We posted the solution JSON file to Cloud Quest 18. 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 19 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:   Many companies require a fleet of vehicles to conduct their business. Eventually, all those vehicles need to be refueled so many of these companies choose to issue credit cards that are assigned to a particular vehicle in the fleet.   While this is convenient, it can result in unscrupulous behavior...   Use the provided datasets to create a workflow that flags transactions that require further review. Transactions that exceed the (vehicle capacity * fuel price) value should be flagged as Level 2, while transactions that exceed 90% of the (vehicle capacity * fuel price) value should be flagged as Level 1.   The Transactions dataset contains fleet credit card numbers, dates, and transaction amounts. The Card Pairings dataset contains Van Number and the fleet credit cards assigned to them. The Fuel Type table contains the fuel types and fuel capacities for three ranges of Van Numbers. Capacities are measured in gallons or kilowatt hours. The Fuel Prices dataset lists average fuel prices by date for regular gasoline (price/gallon), diesel (price/gallon), and electric fast-charging for electric vehicles (EVs) (price/kilowatt hour).   Hint: To make this quest easier, you can simply reference the Fuel Type dataset. However, to make the workflow dynamic, use the Fuel Type dataset in your workflow to account for different van numbers, fuel types, or prices in the future.   A combination of the Join, Filter, Formula, Generate Rows, Select, and Sort 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 and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!   ... View more

Hi Community!   We posted the solution JSON file to Cloud Quest #17. 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 18 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:   You work for a company that has offices in the US and Australia. You want to produce a list for staff to reference when either office is closed for a government holiday so they will know not to expect communications that day.   In the US, if a holiday falls on a Saturday, offices will be closed the preceding Friday. If the holiday falls on a Sunday, employees will have the following Monday off.   In Australia, if a holiday falls on either Saturday or Sunday, employees will have the following Monday off.   Using the provided datasets of US and Australian (AUS) holidays in 2024, complete the following tasks:   Produce a table that lists the date, day of the week, and name of the 2024 holidays for both offices. Determine the total number of business days in Australia and the US in 2024.   Hint: Create a Text Input tool with the Start Date (2024-01-01) and End Date (2024-12-31) and add a Generate Rows tool to establish a list of all calendar dates in 2024.   A combination of the Summarize, Filter, Find Replace, Formula, Join Multiple, and Generate Rows 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 the 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 and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!     ... View more

Hi Community,   We posted the solution JSON file to Cloud Quest #16. 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 17 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:   Marie lives in Toronto, Canada. Every spring, as soon as the weather permits it, she rides her bike to work. Her office is about 15 km away from her home if she drives her car, and a 12 km ride if she bikes.   On Tuesdays and Thursdays, Marie works remotely. On Mondays, Wednesdays, and Fridays, she has to go to into the office. If the temperature gets up to 28 degrees Celsius, she drives to work.   Use the dataset to determine: - How many days did Marie bike and drive in April, May, and June 2021? - How many kilometers did Marie bike and drive in April, May, and June 2021?   Use the “Max Temperature” information provided in the dataset. Note: If the Max Temperature is NULL, assume it is a driving day.   ** Data source: https://climate.weather.gc.ca/climate_data/daily_data_e.html?StationID=51459   A combination of the Filter, Summarize, and Formula 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 the Maveryx 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 and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!       ... View more