Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #39: Trouble Shooting a Broken Macro

GeneR
Alteryx Alumni (Retired)

The link to the solution for last challenge #38 is HERE.

 

This week is a little different, as we work with Alteryx workflows and macros that were created by other people it may be necessary to ‘de bug’ someone else work or make modifications to get components to function in your workflow.   In this case you will start with a macro that had errors and work through the process of fixing it.

 

Use Case:  A bank is looking to calculate customer retention rate month over month. The denominator in the calculation are all of the accounts open 24 months prior to the start of the month. For example, for June 2013, the denominator would be the total number of accounts open between June 1, 2011 and May 31, 2013. The numerator will be total number of accounts closed in June 2013 or between June 1, 2013 and June 30, 2013.

 

Objective: The included macro should calculate the retention rate for May through Dec 2013 but there are errors in the macro.   Your job is to fix the broken Macro.

 

Have fun…

TaraM
Alteryx Alumni (Retired)

A solution has been uploaded

Spoiler
2016-09-06 08_18_24-Alteryx Designer x64 BETA - Batch Macro_Solution.yxmc.png
Tara McCoy
brianprestidge
8 - Asteroid

Nice on this with a couple of sneaky problems in there too!

Solution:

Spoiler
Solution

Change DateTimeParse on two tools
Connect Action Tool to Input
Change open_date and close_date on filter tool
Correct missing ] on formula tool
Allow all appends on append tool
SeanAdams
17 - Castor
17 - Castor

Very similar to challenge 17 - but it was good to bring in the idea of having to debug rather than create from scratch (very important skill)

 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

fixed :)

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! So sneaky...

 

Spoiler
I especially like how the data was formatted in the initial macro input tool fields, with the Start Date after the End Date so that when you try to spot-check the macro it would return 0 results... Tsk tsk! 

WeeklyChallenge39.JPG
estherb47
15 - Aurora
15 - Aurora
Spoiler
Spoiler
1. Connect Update tool to input tool
2. Fix format strings on DateTimeParse tools
3. Fix Append Fields tool to allow all appends
4. Fix field names in Filter tool
5. Fix field name in Formula tool and add closing ]
LordNeilLord
15 - Aurora

Solution:

 

Spoiler
Weekly Challenge 39.png
nick_ceneviva
11 - Bolide

Solution attached

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG