Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution : (although have not renamed the columns as per in the output )
completed using 5 xml parse tools (pity there is'nt an option to expand xml structure in one step)
Never done XML parsing before so I needed a some help on this one
Here's my solution to challenge 37!
Challenge #37, done.
Did not use XML Parse Tool, I chose to parse this as a flat file.
Cheers,
I went a little crazy trying to dynamically rename and order the fields to match the output!
Tried to use as few tools as possible. Used the ability to rename in Join Multiple tool to correct names. Naming connections before joining helps keep track of inputs to select for Join Multiple output.
Here's my solution. Not quite as efficient as the provided solution but a great learning exercise.
Solved