Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #306: Corporate Superhero

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

Weekly Challenge Image 306.png

For this week’s challenge, you’re taking on the role of a corporate superhero out to save the world one workflow at a time.

 

The story: Your company, ABC Consulting, has been providing consultation hours to customers over the last year, but an end of year audit shows that many of the consultation hours have gone unfulfilled. Your goals in this challenge are to reissue a new set of coupon codes against the backlog of consulting hours from FY21, issue new coupon codes for Jan FY 22, eliminate the manual process currently used and create an automated communication that goes out to customers.

 

Currently an employee does the below manual process in order to create coupons codes for customer consultation. She/he:
- Pulls a report of all new orders this month and manually appends them to an Excel sheet
- Filters so orders are in ascending order
- Counts how many coupon codes each customer gets based on $30,000 increments
- Duplicates customer order rows to match the count of coupon codes (so that a row count can be given to this newest batch of codes and added to the current master Excel file)
- Then creates coupon codes with the following format (ABC + Record ID + Order Number + Row Count)
• Ex: ABC13100065001
• After this is complete the employee emails every company’s contact with their allotted coupon codes from this month’s purchases, using the following template.

 

Email Template: (Please feel free to modify if you see value in doing so.)

 

Dear [Company Name],

Please, find below the coupon codes available to you this month for your purchase order volume:

Quantity: [Total Number of Coupons]
Codes: [Coupon Code #1, #2, #3, etc.]

 

Criteria:
• Order Numbers should be filtered into ascending order
• For every $30,000 in dollars spent on orders the customer gets one coupon code for consultation hours
• Customer IDs, order numbers, and coupon codes, should be unique keys
• Both Data Bases provided should be used to cover the totality of backlog of coupon codes and January coupons.

alexnajm
16 - Nebula
16 - Nebula

Done in principle! Hopefully this makes things a lot easier for Stephanie 😁

Kenda
16 - Nebula
16 - Nebula
Spoiler
Not matching given output exactly, but incorporating all requirements nonetheless.

Kenda_0-1644253451680.png

 

chiomaisaiah
6 - Meteoroid

Done

joelmiller66
9 - Comet
Spoiler
Challenge 306 Image.png
balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1644260050539.png

 

AngelosPachis
16 - Nebula

My solution to this week's challenge

 

Spoiler
AngelosPachis_0-1644261658885.png

 

TurboToad
9 - Comet

Fun, nice to learn about the tools for creating the email templates! Getting the sort order/record ID to match took a minute. 

 

Is the coupon formula correct in the output?

Directions say (ABC + Record ID + Order Number + Row Count) but looks like (ABC + Record ID + Order Number + Record ID)...

 

Spoiler
TurboToad_0-1644263585306.png

 

mmotte628
8 - Asteroid
Spoiler
306.PNG

Nice getting a chance to use some tools I don't normally get to

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 306.jpg

Might as well automate the email as well