alteryx Community

# 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.

## Challenge #386: Shed Light on a Bank’s Risky Business

Alteryx

Thanks for picking up these discrepancies!! I will have these records updated shortly :)

16 - Nebula

Some record have thresholds overlapped each other, but was it also a part of challenge??

Anyway, result matches

Spoiler
8 - Asteroid
Spoiler

Fun challenge !

5 - Atom
Spoiler
My solution:

5 - Atom

C386

9 - Comet

A solution:

8 - Asteroid
Spoiler

Decided to recreate lows and highs due to data issue.

Alteryx

Great use for the dynamic replace tool in a batch macro! There is one record that I believe may need to be double checked in the source data - the parameters are duplicated (i.e. amber is >= .03 and green is <=0.03 - it can't be both, one should drop the "=").

Spoiler

Rachel Lynch
9 - Comet

This was a fun one. Went the macro route and worked with the Threshold columns to make it a little more interesting. Giving us the parsed limits pretty much turned this into a beginner-level exercise and didn't seem particularly realistic.

Spoiler
The overlapping thresholds was a nice touch. In the real world, when someone asks us to do an analysis the requestor usually doesn't give us a complete set of requirements (often they don't completely understand the requirements themselves). We have to inspect sample outputs and ask a lot of questions. With these weekly challenges, we can't ask questions but we can look at the output. In this case, we see that we have to evaluate the green threshold first, then amber, then red. (I evaluated red just in case there was a situation where a number fell outside the range of all three thresholds so I could flag it as an out of range error.)

6 - Meteoroid

My solution