Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

logdog0411
8 - Asteroid

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
8 - Asteroid
Spoiler
Spoiler: (First time, sorry if this doesn't post right... 😉

Bellamy WC 302 snip.png

logdog0411
8 - Asteroid

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

logdog0411
8 - Asteroid

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

NicoleJohnson
ACE Emeritus
ACE Emeritus

@Erin 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
11 - Bolide

I think I have them all.

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

Spoiler
dYoast_0-1642015898449.png

 

StephV
Alteryx Alumni (Retired)

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

Steph Vitale-Havreng
cgoodman3
14 - Magnetar
14 - Magnetar

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
14 - Magnetar
14 - Magnetar

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 Alumni (Retired)

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

Spoiler