Split PDF File into multiple PDFs

Hi,

Looking for some help here. I'm trying to split one PDF file into multiple files based on employee ID and save them as separate PDFs. Usually each employee has only one page in the input file, but it could potentially be more than 1, so I'd need Alteryx to read the input file and identify changes on employee ID to know when to create a new file (if an employee has multiple pages, all of them would be placed consecutively).

Any ideas on how to get this accomplished?

Thanks,

Jose M.

Parse

Accepted answers

mceleavey

@jmedinat ,

oops! my mistake. I meant to embed the image in the macro.

It's fixed now.

The one for Employee 1 should have two pages, and the other should have one.

mceleavey solution_intelligence_suite.yxzp

Payslip for Employee - 1556450.pdf

Payslip for Employee - 1.pdf

All comments

mceleavey

Hi @jmedinat ,

Yes, but to achieve this we'll need two things.

First, we need the pdf you're reading in so we know how to build in the separators, and second you will need the Intelligence Suite tools to be able to read and parse pdf files.

If you don't have IS, you can use a few pdf reader tools that are in the community but I can't vouch for how well they work if indeed at all.

Without the original pdf (or one with mock data but representative of exactly how it looks) we can't help you.

jmedinat

Hi Mceleavey,

Thanks for the quick response. I don't currently have a license for IS. The issue is the input files that I'm working with contains employees' sensitive information and I wouldn't be able to share. I could provide a screenshot where I can hide the sensitive information if that would help. If you can point me on the direction of the pdf reader tools I can take a peak and see what I can find out.

Thanks again for your help!

Jose M.

philipmannering

@jmedinat I don't suppose you could share a redacted PDF or something similar to what you're trying to split?

jmedinat

@PhilipMannering @mceleavey I was able to create a file with dummy employee data. The file attached contains 2 employees. one has only two pages and the other one has 1 page only. The field that shows the EE ID is called Empl. no.

Thank you for your help with this!

DummyEE.pdf

mceleavey

Hi @jmedinat ,

I've built this using the Intelligence Suite tools, which does exactly what you need:

This loads the pdf in and parses the text. It then uses regex to determine the Employee ID which is then associated to the image of each individual page. I then wrapped the output in a macro to allow it to group the images to the correct employee and output accordingly.

You then get the attached PDF files.

Without the Intelligence Suite tools you will need to find a macro that has been built that still works (I can't find one) or an R package that will do it for you.

You will then need to change the flow to convert the text back into pdf format.

mceleavey solution_intelligence_suite.yxmd

Payslip for Employee - 1.pdf

Payslip for Employee - 141414.pdf

rosslogie

Really interesting stuff! Has anyone found a way to do this without Intelligence Suite?

Atlasmitchell

I Googled how to split a PDF file into multiple files. Then Google suggested different programs, which I tried. While using these tools, some of them take time to install, while others do not function well and do not give me the functions. Using all of these applications, later on, I downloaded the Pcinfotools PDF Splitter Tool for dividing the PDF based on Google's suggestion, and this application works beautifully without causing any harm to the PDF file's information; it even keeps the attachments intact as I specified. This program also allows me to specify the location of the PDF file on my device, and it is easy to install and virus-free. It can split PDF documents in bulk and has a user-friendly interface, so I used it without difficulty. This software performs smoothly and offers a free trial.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703