Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution, it was difficult for me.
I wanted to parse the headers dynamically but there is no way to do it without setting up some arbitrary rules based on the input data. Indeed, the headers are incredibly badly structured and the input is unreliable as can be seen in the six sample PDF files.
If the headers have to evolve eventually, one solution would be to use a text input tool to dynamically rename the columns based on a provided list.