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're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHere 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.