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.

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

Michael_McKee
Alteryx
Alteryx

Interesting, but when you don't do the D/C step, it causes some issues with the conversion.

Spoiler
Capture.PNG

Spoiler
Capture2.PNG

kelvinlaw
8 - Asteroid

Here is my solution with the extra challenge:

Spoiler
kelvinlaw_0-1642561589385.png
kelvinlaw_2-1642561852613.png

 


kelvinlaw_1-1642561712062.png

 

 

Reesetrain2
8 - Asteroid

All,

 

My solution:

Spoiler
macro.PNG

 I wasn't able to get the drop down, but everything else works.
-I used a find replace to change the comma to a decimal and get rid of the $ and the -

The workflow

Spoiler
Workflow.PNG

 -Cheers!

Matt

balajilolla1
8 - Asteroid
Spoiler
Solution Attached
balajilolla1_0-1642604291514.png

 

alexnajm
10 - Fireball

Great challenge! 

Spoiler
Challenge 303.PNG
Qusaiamer
7 - Meteor

First macro but couldn't run without errors- would appreciate any feedback!

JereJussila
8 - Asteroid
Spoiler
JereJussila_0-1642609827493.png

 

Spoiler
JereJussila_1-1642609854210.png

 

Not the cleanest but does the trick!

atcodedog05
22 - Nova
22 - Nova

My take on this

Spoiler
atcodedog05_2-1642612053466.png

 

atcodedog05_1-1642612035945.png

 

TonyA
Alteryx Alumni (Retired)

Great exercise. I kept the macro interface simple - may have to tweak it later. Let's see what Nicole throws at us next.

EDIT: changed the currency format routine.

 

Spoiler
TonyA_0-1642614941345.png

 

TonyA_1-1642615011518.png

 

 

 

ChristinaFPE
7 - Meteor
Spoiler
This was a good refresher of how to create a macro and I enjoyed learning about the detour tool that I used to complete the bonus part of the challenge.