Hi, I am using the Read PDF tool from Alteryx Gallery https://gallery.alteryx.com/#!app/PDF-Input--Text-and-Image-/5be5ec8d0462d71ffce6deaa This tool can read one pdf file for one run which works great however, I have developed a workflow that parses invoices. One workflow is designed to parse one customer's invoice and many times one customer has hundreds of invoices for a month and in the same identical format. I don't want to: * Duplicate the tool (manually) for the times equivalent the number of invoices in a folder * Run the same workflow for a new invoice every time. Hence, how can I modify this macro so that it reads all the pdf files from one folder and concats the output to a single dataframe thus making my life a lot easier? Help would be highly appreciated. For an example, please find packaged workflow attached and I would be happy to answer any questions promptly. Thanks. Read PDF File_example.yxzp

How to modify macro to read multiple PDF Files in the same Workflow/Input Data Node?

Hi,

I am using the Read PDF tool from Alteryx Gallery

https://gallery.alteryx.com/#!app/PDF-Input--Text-and-Image-/5be5ec8d0462d71ffce6deaa

This tool can read one pdf file for one run which works great however, I have developed a workflow that parses invoices.

One workflow is designed to parse one customer's invoice and many times one customer has hundreds of invoices for a month and in the same identical format.

I don't want to:

Duplicate the tool (manually) for the times equivalent the number of invoices in a folder
Run the same workflow for a new invoice every time.

Hence, how can I modify this macro so that it reads all the pdf files from one folder and concats the output to a single dataframe thus making my life a lot easier?

Help would be highly appreciated.

For an example, please find packaged workflow attached and I would be happy to answer any questions promptly.

Thanks.

Read PDF File_example.yxzp

Workflow

Macros

Help

Optimization

Accepted answers

apathetichell

I usually just insert them via browse - That does seem odd though since it's in your directory... So here's the screen grab and logic.

I turned the pdf tool into the main section of a batch macro. I added a control parameter and an action tool. The action tool updates the

2021-05-09 (1).png

name of the .pdf file.

The outer workflow uses a Directory tool set for *.pdf - it then feeds into the batch macro with filename being fed into the control panel.

Note - I got rid of the text to columns outside of the macro because file identifiers are not generated in the current PDF tools R code. I can take a look at this but not sure what my timeframe would be on editing the underlying R code.

After it returns from the macro, I had a record id and then a text to column /n split. Again this worked on every .pdf in the directory I chose so it should work for you.

All comments

apathetichell

Try this. It worked for me in terms of reading in all .pdfs in a set directory.

A few notes - generating record ids is a work in progress and could be problematic if different files have multiple component parts which are non-static. IE each record should basically have the same number of parts for easier identification.

If that's not the case let me know as it'll take some playing around in R.

workflow test.yxzp

HW1

@apathetichell What version of Alteryx are you using?

I am getting this error

apathetichell

2021.1 you can edit the workflow/macro in notepad to change that. What version are you running? Having said that - I'd try running it in a 2020 version first - I'd be surprised if there were any features which cause you trouble.

HW1

How do I downgrade your workflow to be able to work in my version?

I am a bit hesitant to upgrade because the last time I did that, it broke my pdf parsing workflows as I needed the updated R dependency which was (then) not available. I had to roll back.

apathetichell

Yeah I had to upgrade today because of broken R stuff too. I changed the versions in notepad on the .xmd and .ymc - make sure the directories are set up for you and not me and give it a try...

If those don't work - I'll just post a screen grab. It's pretty straightforward.

workflow test.yxmd

pdfbatchmacro.yxmc

HW1

Surprising, This is new to me!

I am unable to find my macros in the tool palette even after adding it to the appropriate folder and restarting my alteryx.

If you can help me with screenshots to make it work would be great!

However, why would be the case that I am unable to see my macros on my tool palette?

I am looking into my tool palette however the macros folder does not show up?

apathetichell

I usually just insert them via browse - That does seem odd though since it's in your directory... So here's the screen grab and logic.

I turned the pdf tool into the main section of a batch macro. I added a control parameter and an action tool. The action tool updates the

2021-05-09 (1).png

name of the .pdf file.

The outer workflow uses a Directory tool set for *.pdf - it then feeds into the batch macro with filename being fed into the control panel.

After it returns from the macro, I had a record id and then a text to column /n split. Again this worked on every .pdf in the directory I chose so it should work for you.

HW1

Yep, upgrading the version worked.

However, I have a question:

Is the folder here has to be the same?

I mean, if I have different folder to work this macro on, will I have to update this value and save the macro to make it work?

apathetichell

Hi,

You'll have to change the directory to whatever directory you want to get the macro to run. Or in the alternative - you can change it into an app and attach a folder browse & action tool to the directory tool. That will allow the user to change the directory and run the macro on that directory.

If your question is about the batch macro app - as long as the entire path is being replaced/updated I do not think the directory listed in the initial settings of the control parameter/action tool matter. They will be updated with whatever comes through the control parameter. If there is a problem then the full path would have to be passed through instead of the filename.

apathetichell

also - check out macros under options/user settings and make sure your path is there. That should allow you to put macros on your tool palette I think.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703