Alteryx Academy

Congratulations on completing Exercise 2!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

A solution to last week’s challenge can be found here.   As the world grapples with the transition to more sustainable energy production, nuclear energy is often forgotten despite the many reactors that exist in countries all over the world. Use the provided datasets to generate a report giving a high level overview of the world's current nuclear capacity.   Use the 4 files containing nuclear reactor data to create a report including the following: A map showing the locations of reactors with a status of: "operational", "under construction", or "planned" (only include reactors with a set location) A table listing - by country - the number of operational reactors, the total capacity of those reactors, and the most common type of operational reactor. (only include reactors presented in map)     Dataset from www.kaggle.com Designer Version Used to Create: 2018.4 ... View more

Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback.  The link to the solution for last challenge #33 is HERE.  For this chalenge let’s look at creating a macro from scratch.  I recommend you first solve the problem with tools on the canvas, then cake a macro from the tools.   Use Case:  Our customer has a need to convert date/time strings into a date-time format.   Examples of the different input formats include:  4/8/2015 4:00, 5/10/2015 13:00.  The conversion is automatic when the hours are 2 digits (10-24), but it ignores hours 1-9 (creates NULL values on conversion).   Objective:  Create a macro to effectively convert and preserve the data in a date-time format. ... View more

Congratulations on completing Exercise 4!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

A solution to last week’s challenge can be found here.  Source: https://snaped.fns.usda.gov/seasonal-produce-guide/mushrooms   This week's challenge focuses on a dataset describing mushrooms which has been encoded. In the 23 columns describing each mushroom observed, the values are represented by a single character. Use the Attribute Info table to replace the coded information with the values they represent. ... View more