Learn

Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some renaming per the sample output. Good luck, I look forward to your feedback. ... View more

A solution to last week's challenge can be found here!     Tires: they smell bad and can be expensive, but we all need them. For being a basic piece of technology, they have a huge impact on arriving safely at your destination.  For instance, the "contact patch" refers to the amount of a tire contacting the surface of the road. The size of a contact patch has a huge impact on stopping distance, traction, and even fuel economy. It's a similar story with tire height.   When looking for new tires, it can be useful to get information about a tire's width and height. Many sites have "tire calculators" which allow a user to enter a tire's size in a standard format and view more information on that tire. The standard format for tires is tire width in millimeters, a percentage of that width as the sidewall's height, and the radius of the rim in inches (e.g. 285/70/R17 is a 285mm wide tire, with a sidewall size of 199.5mm (285*.7), and fits on a 17" rim).   For this week's challenge, create a chained app to allow users to enter tire size information and view the additional information on file. Update the next field after the user makes a selection so that only existing options are available.       Your app interface should look similar to this:  Create a three-step app to find tires based on width, sidewall height, and rim radius.         ... View more

Here is a new challenge for this week, it is a continuation from last week’s warehouse distribution challenge. If you did not complete last week’s challegne don’t worry, you will not need any output from part one to complete this part.  The link to the solution for last week’s challenge is HERE. I posted two solutions for last week’s challenge. The first is a solution without a macro and is in my opinion a more straight forward approach to solving the problem. I included the second macro approach because it is an excellent example of how to utilize an iterative macro.   The use case:   Based on data from last week’s warehouse distribution challenge , we want to calculate the total shipped miles per item. The products are available from 3 different warehouses, lat/lon data is provide for each warehouse and each store location.   Your goal is to find the total distance travelled as straight line miles for each item based on it being shipped from the closest warehouse.   Good luck, I hope you are having fun with these challenge  and expanding your knowledge of Alteryx. Thanks to all that have provided feedback. ... View more

A solution to last week's challenge can be found here.  Source: https://en.wikipedia.org/wiki/Gender   In general, there are slightly more men than women in the world. According to the United Nations, the number of men is rising gradually each year since 1960. However, some statistics show this is not the case in certain countries. In former Soviet republics, for example, women outnumber men. Conversely, there are more men than women in Asia, Arab countries, and Northern Africa, but what about in Latin America?   This Input data for this challenge is an Excel file containing data with the long-term population estimates and projections from 1950 to 2100. Use it to answer the following questions: 1. What was the last year in which there were more men than women in a Latin American country? 2. In what year will the percentage of men in a Latin American country reach the lowest point according to this dataset? 3. Is there any chance that it will be more men than women by 2100? In which Latin American country? ... View more

Here is the new weekly challenge. The link to the solution for last challenge is HERE. For this challenge  let’s look at ranking records when multiple records can have the same rank. The objective is to determine the top 5 ranking based on the count, however since there are multiple rows with same count (similar to a round of golf) multiple people can be in the same place (Rank) if they have the same score.   We have listed this as a beginner challenge  and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.   UPDATE 1/25/2016 The solution has been uploaded. ... View more