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 #302: International Bank of Awesome Data - Part I

anabelvelazque
8 - Asteroid

Hi! Here is my take 🙂 

 

Spoiler
anabelvelazque_0-1641919163832.png

 

atcodedog05
22 - Nova
22 - Nova

Here is my take

 

Spoiler
atcodedog05_0-1641925100874.png

 

Erin
9 - Comet

Really enjoyed this one and feel my RegEx skills growing stronger!

 

QUESTION:  I do have 2 items showing differently in the bonus that I think *respectively* that the weekly challenge crew might have wrong.....

Spoiler
Apologies on the messiness of the bonus. I am sure there is a cleaner easier way of doing this without the running total nonsense. Anyways, the two areas I'm hoping for clarity: 

1. Alteryx crew has [Bank Account Number]='R60204-89855284-21' and I am pretty sure it should be '602048-98552842-10'.
2. Alteryx crew has [Opening Balance]='0 82002,9' when I am pretty sure it should be '82002,92'.

 

 

Michael_McKee
Alteryx Alumni (Retired)

Lots of Prep and Blend

 

Spoiler
Capture.PNG

DaisukeTsuchiya
13 - Pulsar
Spoiler
キャプチャ.JPG

NiallJ
7 - Meteor

I'm having an issue with the Files on the Weekly Challenge.

 

I can download the Workflow and run it but when I save it and try running again I get an Error - Files not found.

 

Does anybody know what the issue is and how I can address it?

JereJussila
8 - Asteroid

Great challenge!

Spoiler
JereJussila_0-1641979233128.png

 

alexnajm
16 - Nebula
16 - Nebula

No extra credit today 😞 but a very nice challenge!

 

Spoiler
Wow that is a complicated RegEx!Challenge 302.PNG

 

 

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1642002380843.png

 

TonyA
Alteryx Alumni (Retired)
Spoiler
The bonus part had me confused until I realized it was actually a report with section headers and all lines starting at the left margin. I tweaked the regex for Region C to correct a misalignment in one of the C rows so I have two errors in the third check.
TonyA_0-1642002262863.png