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.
Super new to alteryx so sorry if the question has been solved in some way before...
I am trying to concatenate some data together on CCG health budgets. The budget is split into 3 categories (core, primary care, and specialised services). Each CCG gets funding for the 3 segments, but the data is split into 3 pdfs (https://www.england.nhs.uk/allocations/)
CCG allocations 2019/20 to 2023/24 (core services)
CCG allocations 2019/20 to 2023/24 (primary care medical)
CCG allocations 2019/20 to 2023/24 (specialised services)
Does anyone know how to extract the pdf tables into an alteryx-workable format?
It involves uses a number of R packages to pull out the data from the files, which can be parsed in Alteryx from there. If you need any more help feel free to let me know and i'll take a deeper dive into it for you.
If this solves your issue please mark the answer as correct, if not let me know!
thank you for your reply. Unfortunately I didn't make it very far into the article because I don't have the R tool in my Alteryx Designer... When I tried to get the R tool for Alteryx I got the error message below: