This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!
Also, I have a question. After working through Region C, I figured out I could apply the same approach (based on length of the fields) to Region B. I saw the hint say each field of Region B file contains 40 characters. How did you arrive to this number?
Challenge_302_Start File (Corrected) - My Solution.yxmd
Now that's a fun challenge. I'm so out of practice, but the urge is still there to make it as dynamic as possible. Minimal changes would need to be made if fields changed. I was tempted to pull out CReW Dynamic Formula for the REGEX, but it wasn't too hard to dynamically build the REGEX without it. I would like to make a lookup table to rename the fields...