Alteryx Academy

  Hello Community members,   A solution to last week’s challenge can be found here.    This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this incredible challenge!   Every year, parents and guardians need to purchase school supplies for their children at the beginning of the school year. This is a major cost that many families struggle to budget for.   In Part 1 of this challenge, your objective is to calculate the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade).   There are two datasets provided: School Supply List Text Input: A list of school supplies separated by grade. Cost of School Supplies Text Input: The cost of each unit from a list of school supplies.   Need a refresher? Review the following lessons in Academy to gear up: Changing Data Layouts Sorting Data   Ready? Good luck! The Academy Team   Download Start File   Data Source: https://www.in.gov/doe/it/data-center-and-reports/ ... View more

A solution to last week’s challenge can be found here. Now that you have created a map of the marathon route in Part 1 of challenge #341, add details to your map: - Create a start point in green. - Designate the route in red. - Create a legend in the lower-left corner for the start point and the route. Use an 11 x 6-inch card size. Add the following numerical information in the upper-right corner: - Marathon distance - Route time - Average speed Hint: Respect the formatting of the caption objects.   Check out our newly rebranded course, Spatial Analytics. ... View more

The link to last week’s challenge (challenge #20) is HERE.  For this week’s challenge we have an easier one that requires the reformatting date fields.  The input data has very poorly formatted month and year information that will require you to build some logic to make it usable.    Use Case: A company needs to reformat a month/year flag in a data asset they received for a consulting project. You will need to take the Date field provided and separate it into fields for the Month and Year.  For example, F07 should become 2 columns where month is Feb and year is 07.   Have fun! ... View more

A solution to last week’s challenge can be found here. Laurent, a French runner, created a marathon route in Paris representing the map of France.   This dataset contains marathon information such as the route stops; latitude and longitude; and timestamps.   Based on the data in the file provided, produce a map with the details of the marathon route. This is Part 1 of the challenge.   Check out our newly rebranded course, Spatial Analytics. ... View more

A solution to last week's challenge can be found here!   This week's Challenge come to us from @T_Willins!    Your tax group has advised you that the information they need is available only in a .TXT report. To properly import the data into a subsequent system, they need the data filtered and in a specified format.   First, match the ID no. from the totals rows to the corresponding detail lines. Then filter to only detail rows with a tax codes of P1 or P9. Format, sort order and field names on the output file must match the given output for the file to load correctly.       ... View more