Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extract data from PDF with Password using R Tool (pdftools)

RichardAlt
8 - Asteroid

Hi All,

 

How to extract data from PDF file with password. I've installed PDFInput Tool on my designer I have no problem when the PDF file is not password protected. 

 

This is the default R Code in PDF Input.

# read in the PDF file location which must
# be in a field called FullPath
File <- read.Alteryx("#1", mode="data.frame")
 

# Use pdf_text() function to return a character vector
# containing the text for each page of the PDF
Data <- pdftools::pdf_text(file.path(File$FullPath))
 
# convert the character vector to a data frame
df_Data <- data.frame(Data)
 
# output the data frame in steam 1
write.Alteryx(df_Data, 1)
1 REPLY 1
BrandonB
Alteryx
Alteryx

That tool from the gallery uses the pdftools R package. If you look at their documentation you will see that you can pass owner/user passwords in the command: https://cran.r-project.org/web/packages/pdftools/pdftools.pdf 

 

BrandonB_0-1634137151118.png

 

Labels