Learn

A solution to last week’s challenge can be found here.  Source: GIPHY   This challenge comes to us from @ramesh_neel - thank you for your contribution!   The input file has names of users connected by commas in a single field with random numbers to each name . Some of the names start with a lower case and some have middle name to them. [ names generated using a random name generator website ]   Create a set of email IDs (using @testemail.com as the domain) using a combination of first letter of the first name + last name of the user [even if they have a middle name ] and grouped into A-Z categories. Provide a count of the number of emails in each group.   Hint - In your output exclude any users without a valid name ( i.e, does not contain a number) ... View more

Wow!  Thanks to everyone who posted their solution to last Week's Challenge here!  It was great to see everyone's creativity and different approaches to solving a problem.  We had some submissions for different locations (and hemispheres!), as well as some tweaks to put a unique analytical spin on the original problem.  We also had some new Challengers!  Woohoo!    This week's Challenge was inspired by a recent conversation I had with an Alteryx user at Inspire in London a few weeks ago.  In this case, he wanted to figure out how many combinations of products he had in a dataset.  We spoke about a few different approaches, and I'm curious to see how the Community responds to this Challenge.  Have you had a use case where you've needed to accomplish something similar?  What other tweaks can you think of that might make this Challenge relevant for other tasks?     The Input dataset contains a list of twenty (20) transactions.  Each transaction contains a list of items that a customer purchased at the market.  How many combinations of the same objects were purchased?  In this case, the order does not matter.  That is, the combination of "carrots, tea, shampoo" is the same as "shampoo, carrots, tea".     ... View more

Hello Maveryx,   After a two-week hiatus from our weekly challenges, while we all attended Inspire, we're back to our regular routine! I hope you enjoyed your break!   A solution to last week’s challenge can be found here.    This challenge was created by @Qiu and inspired by a question posted in our Community. Qiu, your contributions are priceless, and we cannot thank you enough!   The dataset contains a single column with the total monthly allowance for each person in a group of five teenagers. In an effort to budget their money, they want to determine how much, if anything, they would have left over if they budgeted $150 of spending each week for the first four weeks of the month.   Your task is to allocate the money by dividing each teenager’s total amount over five columns representing each week of the month plus a carryover week (Week 1, Week 2, Week 3, Week 4, Carry_Forward), considering their weekly spending limit [$150]). Any remaining funds after the first four weeks should be rolled over into the Carry Forward column.   Need a refresher? Review these lessons in Academy to gear up: Multi-Row Formula Writing Conditional Statements   Good luck!   ... View more

Hi Maveryx,   A solution to last week’s challenge can be found here.   Patrick Digan (@patrick_digan)  submitted this challenge that will test your logic skills. Thank you, Patrick, for submitting this great challenge!   You have a dataset that looks like this:   Record A B C 1 1.0 0.0 0.0 2 1.0 0.0 0.0 3 2.0 1.0 0.0 4 ? ? ?   Your task is to generate rows for records 4 through 25 (1 to 3 will stay the same), and calculate the values of A, B, and C for each row.   The general logic to determine the values in columns A, B, and C for records 4-25 is: Column A: Calculate the sum of all numbers in the previous row. Column B: Subtract B from A in the previous row. Column C: Subtract B and C from A in the previous row.   Hint: You will need to make sure that you calculate the values record by record.   Example for Record 4: A=2+1+0=3 B=2-1=1 C=2-1-0=1   Example for Record 5: A=3+1+1=5 B=3-1=2 C=3-1-1=1   Need a refresher? Review the following lessons in Academy to gear up. Changing Data Layouts Multi-Row Formula   Good luck!   ... View more