Saving .pdf pathways to a dedicated folder

Hi all,

I have a workflow in Alteryx that scrapes certain kinds of .pdfs from a local server.

The output is an Excel sheet with the type of .pdf in column A and the pathway in column B.

Example:

Type	FullPath
123.12	C:\Users\Username\Documents\PDFtypes/document1.pdf
123.12	C:\Users\Username\Documents\PDFtypes/document2.pdf

Right now I have to click the hyperlink manually and click 'Save As' to store it in a dedicated folder.

The problem is that there are 1000+ .pdfs which would take a while to store manually.

Is there a way to store them automatically? I've tried searching here but didn't find a direct answer. My apologies if this is a repeated question, I'm still learning the ropes.

Thanks in advance!

Batch Macro

Accepted answers

Sebastiaandb

@shey Here you go. Just put the list with paths to the pdf files in the first text input tool. You can make a batch macro of this as well, depends on what's easier for you :-).

pdftransport.yxmd

All comments

Sebastiaandb

He! @shey

Can you make a dummy?

What do you want it to do? It scrapes like 1000+ pdf's now from a directory and puts a path in a Excel table? From my understanding you want to save a certain file in each of those paths, might be using the Run command tool for that but i need some more insight :-).

Greetings,

Seb

shey

Hi Seb,

I get that my explanation was a little vague.

I'm actually talking about getting all of the .pdfs from different folders into one folder so that I can run a workflow with that folder in Alteryx that converts the .pdf to .csv so that I can transform the data.

To be more precise: the pathways from the excel sheet open up a .pdf, which I need to save to a folder, (i.e the folder 'pdfs' on my desktop). Currently I'm opening the pathways and then manually saving them to that folder, but I want it to be automated.

Sebastiaandb

@shey Here you go. Just put the list with paths to the pdf files in the first text input tool. You can make a batch macro of this as well, depends on what's easier for you :-).

pdftransport.yxmd

shey

Works like a charm, thank you! 🙂

Sebastiaandb

@shey No problem, glad to help! 😄

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335