Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
My solution! I was not matching back to the output as there were some cases it didn't match the input file. Program ID = 13642 is an example. The Piece IDs don't match fully to the XML. @ChristineB
Spoiler
I had to do a lot of testing with the XML parse tools and continually copy and paste to look at the fields I wanted tot parse and ensure I was getting the correct results. Very tough challenge!
Spoiler
I ignorantly didn't really understand the structure of xml and what the xml parse was really doing, so I only used one, and then tried to parse out the rest using regex and multirow formulas. I did think it must be easier (!) and so after finishing, I looked at the spoilers and used several xml parse tools as in the solution.
I ignorantly didn't really understand the structure of xml and what the xml parse was really doing, so I only used one, and then tried to parse out the rest using regex and multirow formulas. I did think it must be easier (!) and so after finishing, I looked at the spoilers and used several xml parse tools as in the solution.
