Saving .pdf pathways to a dedicated folder

[shey]

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!

[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 · Accepted solution]

@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 :-). 

[shey]

Works like a charm, thank you! 🙂

[Sebastiaandb]

@shey No problem, glad to help! 😄