Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.Install R Packages
Packages are installed in the user's personal R library folder (example: C:\Users\%windows_account%\Documents\R\win-library\%R_version% where %R_version% is the current R version, like 3.4 for example). It is one for the folders that R searches by default to find available R packages. If installing to a different folder, ensure you have write permissions to that folder.
Another common method would be to use the standard R package install function within the R Tool:
install.packages("package_name", repos="https://cloud.r-project.org")
Note that this function has several options that may be required depending on your environment and the package you are installing. For reference, documentation for this function can be found at this link .
Whatever method you use, don't forget to call that package in your R code, using library() .
Happy Alteryx-ing!
Hi CristonS,
Please find below the code which I writing on R tool to install packages, along with the messages which I am getting for the same.
Note: I have reinstalled all the components of Alteryx along with the predictive packages. But I am still having problem installing the required packages using R tool. It would be very helpful if you can help me solve the problem.
Yes, I believe I am using the Admin version.
Still unresolved.
Simple test.
Use the .libPaths() command in the Alteryx R Terminal.
PS C:\Program Files\Alteryx\R-3.3.2\bin> R.exe R version 3.2.3 (2015-12-10) -- "Wooden Christmas-Tree" Copyright (C) 2015 The R Foundation for Statistical Computing Platform: x86_64-w64-mingw32/x64 (64-bit) R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. Natural language support but running in an English locale R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > .libPaths() [1] "C:/Program Files/R/R-3.2.3/library" >
Check - Works as expected.
Try the same command in the Alteryx R Tool
Spent yesterday unintall/install versions of Alteryx designer and the predictive tools. Changing system environment variables for R_HOME, R_LIBS_USER. Modifying the Rprofile file in base.
Same result. R Tool and Predictive Analytics are now completely disabled in Alteryx Designer. Frustrated and demoralized.
@ejtesoriero !
I just use a line in an R Tool to install packages. I've attached a tiny workflow that does two things. It finds all your libraries and their locations and also installs packages.
Hmm, seems I cannot add an attachment. Here's my discovery code (in the "get libraries" container), to see which packages are installed and where.
libs <- .libPaths()
length_vector <- vector("integer", length(libs))
loop <- 1
for (lib in libs)
{
temp_dirs <- as.list(list.dirs(path = libs[loop], full.names = FALSE, recursive = FALSE))
length_vector[loop] <- length(temp_dirs)
loop <- loop + 1
}
max_length <- max(length_vector)
loop <- 1
the_dirs <- list.dirs(path = libs[loop], full.names = FALSE, recursive = FALSE)
length(the_dirs) <- max_length
the_library <- as.data.frame(the_dirs)
colnames(the_library) <- c(libs[loop])
loop <- loop + 1
loopy <- c(loop:length(length_vector))
for (loop in loopy)
{
temp_dirs <- list.dirs(path = libs[loop], full.names = FALSE, recursive = FALSE)
length(temp_dirs) <- max_length
temp_library <- as.data.frame(temp_dirs)
colnames(temp_library) <- c(libs[loop])
the_library <- cbind(the_library, temp_library)
}
write.Alteryx(the_library, 1)
Funny thing, I copied this from a workflow I used to duplicate R installs to a new server. One of the packages I needed to install was pdftools. So here's a line from the Container labeled, "install packages."
install.packages("pdftools", repos="http://archive.linux.duke.edu/cran", lib = "C:/ProgramData/Alteryx/R-library")
Hope this helps!
Best,
David
@ejtesoriero !
The problem lies in getting a Blob into the R package. You need to convert it to Base64 binary before the R Tool and convert back into a blob in R.
library(pdftools)
library(base64enc)
the_data <- read.Alteryx("#1",mode="data.frame")
the_vector <- as.vector(the_data[1,1])
the_blob <- base64decode(the_vector, output=NULL)
# Use pdf_text() function to return a character vector
# containing the text for each page of the PDF
txt <- pdf_text(the_blob)
# convert the character vector to a data frame
df_txt <- data.frame(txt)
# output the data frame in steam 1
write.Alteryx(df_txt, 1)
Happy hunting and good luck!
Ciao,
David
No matter what command I run in the R Tool I get the below error:
R (2) Error: package or namespace load failed for 'stringr' in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
R (2) Execution halted
R (2) The R.exe exit code (1) indicated an error.
Any help would be appreciated!
@ejtesoriero
I'm not sure, but I would first look at rlang because of the line in the messages that says that you don't have all the dependencies installed that you need.
