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 #386: Shed Light on a Bank’s Risky Business

braveraj
10 - Fireball
Spoiler
Alteryx Challenge Risk Workflow.pngAlteryx Challenge Risk Results.png
Watermark
12 - Quasar
12 - Quasar

@ggruccio   yep, data issues.  KRI4634 & KRI9101

 

Spoiler
MT_Solution_386.jpg

ARussell34
8 - Asteroid

Great way to start off the week. I learned about the "between" function and it has been really useful, especially in this problem.

M__K__A
7 - Meteor

My solution is attached.  I think I did this correctly, however I have a few results that differ from the provided output.  I believe there may be some discrepancies unless I am misinterpreting the records...

olga_strubbe
10 - Fireball

Thank you, @hannah_malek!  This was a nice challenge.  It helped me practice my batch macros. 

 

Solution I:  standard workflow

 

2023-08-28_21-41-40.png

Solution II:  Batch macro

2023-08-28_21-41-00.png

 

 

 

rmassambane
10 - Fireball

386!

Sebastian_Chaieb2
8 - Asteroid

Initially I was building my solution based on [Red_Sign] field, however it looks like there is an error with the data as it dose not match specification . So I decide to use [Green_High] when it is NULL.

 

My Solution below:

Spoiler
386.PNG
DaisukeTsuchiya
13 - Pulsar
Spoiler
A few record didn't match with Output.

Spoiler
スクリーンショット 2023-08-29 165303.jpg

Flo_P
8 - Asteroid
Spoiler
A strange challenge with unclear and overlapping data. If there was a lesson here, I didn't learn it.

image.png
ed_hayter
12 - Quasar
Spoiler
Interesting Conceptual Challenge - think if the input data was more varied it would have been more fun. In the end it was varied but not enough to irk a long-winded formula.

image.png