Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy first time posting a solution. Please feel free to provide feedback. Thank you!
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?
Great challenge for those looking to upskill on data prep!
Region A and B only
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...
Few issues encountered. For C, don't know who to join for the final stage, how to join the Bank Branch to individual Bank Account.