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

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1642106422436.png

 

TH
7 - Meteor

I didn't bother rearranging the order at the end because That was not really the point of the exercise.

I had trouble finding the date for Region B for a while until I saw that someone showed a simple way to determine which digits it was.

I look forward to next week.

 

Edit: Made some updates to part C *Extra Credit" due to a new understanding.

I wonder how I'd do this in Python....

Spoiler
TH_0-1642176277861.png

 

 

SupperWoman
5 - Atom

2022-01-14 12_42_22-Alteryx Designer x64 - Challenge_302_Solution_LeonaL.yxmd_.png

cgrace
8 - Asteroid

Wish I took a look at the Region B hint earlier.  I was having trouble parsing the string till I realized they are all 40 characters long.  Also, in hindsight I should have used the line 1 headers, I ended up just retyping the column labels.

 

Spoiler
cgrace_0-1642125269960.png

 

NiallJ
7 - Meteor

I've had one response thanks for that. Sorry I can't see it to respond directly.

 

I'm still having a nightmare here. I saved down my own version of the input files but it changed the Bank Account Number to Scientific Numbers - I've spend about 2 hours trying to get Reg. Ex to insert the "-" thinking the issue was my lack of Reg Ex skill but just noticed that the the Bank Account Number isn't in Scientific format on the original file.

 

I assume this is a Wins 10 issue as everything seems harder since I was **downgraded** from Wins 7!

allwynthomas24
8 - Asteroid

Thanks for this amazing Challenge. @NicoleJohnson .. But the "Extra Credit Part" needed too much brainstorming and it truly gave Real World Data Extracting experience. It was a Brainstorming Friday.. Thanks..

 

Region A & Region B

 

Spoiler
allwynthomas24_0-1642169307535.png

Region C (Extra Credit)

 

Spoiler
allwynthomas24_1-1642169372379.png
NicoleJohnson
14 - Magnetar
14 - Magnetar

@allwynthomas24 You are totally correct about it being a Real World Data Extracting experience!! In fact, the idea for that particular extra credit questions 100% came from data I had to figure out how to parse in a similar way at work 🙂 Glad you enjoyed it!

 

NJ

SFOSTER
5 - Atom
Spoiler
SPOILER

SFOSTER_0-1642177516768.png

 

allwynthomas24
8 - Asteroid

@NicoleJohnson  Hey I am really happy to know that the challenge was based on the actual datasets. It help me to improve my understanding on String Functions and also boosted my confidence. Do post such real world challenges in the future. Thank You.!

Regards.

 

Allwyn Thomas

tammybrown_tds
8 - Asteroid

I used way too many tools to get there, but I got there nonetheless.