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

logdog0411
7 - Meteor

Had to peek at yours to figure it out - I was not familiar with RegEx before. 

 

I studied up and got the concept. Thanks for the help!

logdog0411
7 - Meteor
Spoiler
Spoiler: (First time, sorry if this doesn't post right... 😉

Bellamy WC 302 snip.png

logdog0411
7 - Meteor

Of course I got it wrong! Shows you how often I use message boards...

logdog0411
7 - Meteor

Super elegant solution here Aaron. I had to study it a bit to understand what you did. 

NicoleJohnson
14 - Magnetar
14 - Magnetar

@BronzeFox Nice catch! Looks like an issue with a character in the input file that looks like 1 character but is ending up translated somewhere as 2, so it's throwing off the character counts on that record. Special characters are always fun when working with data... *oops* 

 

I'll have an updated start file/solution uploaded asap! Thanks for the diligent sleuthing 🙂 

 

NJ

dYoast
8 - Asteroid

I think I have them all.

Here is A and B.  C is too large for a screenshot.

Spoiler
dYoast_0-1642015898449.png

 

StephJ
Community Manager
Community Manager

Thanks for this great ACE Challenge 🥁🥇 @NicoleJohnson! I'm sure you'll inspire other ACEs to follow your lead @RolandSchubert , @Ladarthure, @carlosteixeira 😎

Steph Jansen-Havreng
cgoodman3
13 - Pulsar
13 - Pulsar

The workflow is downloaded as a packaged workbook and the files are relative. Therefore if you re-save the workflow into a different folder then the relative paths don't know where your data is, I suggest either saving the workflow in the same folder as you downloaded it, or changing the file paths to locate the original files.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman3
13 - Pulsar
13 - Pulsar

Can I have my extra credit please.

 

Spoiler
For Region A and B I used extra tools to split out the formulas just so it is easier to understand the transformations being applied, in addition I was hoping to be lazy with the field renames hence the dynamic renames but in the end need to manually rename the fields in select tools.
cgoodman3_0-1642075759109.png


Then part c using regex to parse out the fields based on field size, then rebuilding it back to the report table structure.

cgoodman3_1-1642075823845.png

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
MatthewBr
Alteryx
Alteryx

Always good to test my ability to parse.  This happens in the real world all over the place.

Spoiler