We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #303: International Bank of Awesome Data - Part II

Watermark
8 - Asteroid

 Let the Macro do the work .....

 

Spoiler
MT Solution 303 flow.png



MT Solution 303.png

anabelvelazque
8 - Asteroid

Hi! Here is my take 🙂 

 

Spoiler
anabelvelazque_0-1643148211796.png

 

ryan-bush
Alteryx
Alteryx

Great challenge for some macro practice!

Macro:

Spoiler
ryanbush_0-1643224308110.png

 

Workflow:

Spoiler
ryanbush_1-1643224323957.png

 

mbogusz
9 - Comet
Spoiler
Weekly Challenge #303 in the canWeekly Challenge #303 in the can
kimlam
5 - Atom
Spoiler
I really like your solution and tried to recreate part of it on my own. However, for the Action tool connected to the Select tool, it doesn't show all the fields. It shows "Unknown" instead. Did I miss anything?
kimlam_1-1643506170780.png

 


 

Qiu
19 - Altair
19 - Altair
Spoiler
Challenge 303.PNG
jduracka
Alteryx
Alteryx
Spoiler
jduracka_0-1643644803527.pngjduracka_1-1643644835466.pngjduracka_2-1643644873435.png

 

 

allwynthomas24
11 - Bolide

Thank you very much @NicoleJohnson for such an data cleaning series... Much needed exercise as I am learning and trying for Alteryx Advanced Certification... 

 

 

 

Spoiler
Workflow:
allwynthomas24_4-1643743571787.png
Spoiler
Macro:
allwynthomas24_5-1643743601192.png

 

 

ainderike
8 - Asteroid

What a blast! See my solution below.

Spoiler
I tried to create a macro that would be as dynamic as possible. However, I couldn't figure out how to deal with Debit/Credit or Currency Code fields, because if these are not present in a dataset, macro would not work as intended. Otherwise seems like I managed to address the most common scenario, i.e. what if a report is enhanced with additional fields (credit line limits or closing balances) that have to be converted to USD.
 
 

Macro.PNGMacro Interface.PNGWorkflow Results.PNG   

 

jpl5253
7 - Meteor

Solution File attached