Alteryx does not recognize R lemon package
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm using R lemon package to build out some charts. However, after running my workflow I'm getting the error message in the attachment.
I have the lemon package installed on my machine but Alteryx is not recognizing it.
I'm using Alteryx 2018.4 and I have downloaded the updated version of the lemon R package.
Is the error a result of Alteryx 2018.4 not compatible with the lemon package?
Here are my R codes:
.libPaths()
mydata <- read.Alteryx("#1", mode="data.frame")
AlteryxGraph(1, width=12000, height=6000, res=500)
library(ggplot2)
library(lemon)
mydata$Numb <- mydata$Count
# Stacked
ggplot(mydata, aes(x=DateCalc, y=Count, fill=ItemDue)) +
geom_col(position = "stack", width = 0.2)+
facet_rep_wrap(~FinalAuditName,scales = "fixed", repeat.tick.labels = TRUE)+
scale_y_continuous(breaks=seq(0, 10, 1))+
theme(axis.text.x = element_text(angle = 45))+
theme(axis.text = element_text(size = 6))+
theme(axis.title = element_text(size = 10))+
ggtitle("Audit Finding Due Date Forecast")+
xlab("")+ ylab("# of Deliverables")
invisible(dev.off())
Solved! Go to Solution.
- Labels:
- R Tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It looks like the 'ggplot_add' is a dependency of the lemon package which isn't installed.
I've created a post which you should be able to re-work to automatically get and install all required dependencies here:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much! This works well for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
After I install the R packages extensions all is working well until I published the workflow to the server.
I received the below message when I ran the workflow from the server. Does this mean Alteryx server doesn't have the R package extensions? If so, how do I fix this?
Oops!
The job FindingsReport_Infra_RE did not complete successfully and resulted in the following errors:
- Error in library(lemon) : there is no package called 'lemon' (Tool Id: 232)
- Execution halted (Tool Id: 232)
- The R.exe exit code (1) indicated an error. (Tool Id: 232)
- Error in library(lemon) : there is no package called 'lemon' (Tool Id: 175)
- Execution halted (Tool Id: 175)
- The R.exe exit code (1) indicated an error. (Tool Id: 175)
- Error in library(lemon) : there is no package called 'lemon' (Tool Id: 296)
- Execution halted (Tool Id: 296)
- The R.exe exit code (1) indicated an error. (Tool Id: 296)
- Error in library(lemon) : there is no package called 'lemon' (Tool Id: 333)
- Execution halted (Tool Id: 333)
- The R.exe exit code (1) indicated an error. (Tool Id: 333)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It looks like the packages aren't installed on your Alteryx Server, which is why youre getting these errors.
Once the packages are installed on the server, you should be able to run the script - you can install them using Designer on your Alteryx server.
Note: Dependencies also need to be installed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much for your reply.
Can you share the instructions how to install the packages with the dependencies on the server? I want to make sure I'm doing this the right way because we will be using a lot of R packages in our workflows.
Looking forward for your reply.
Thanks,
Deoraj.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's a blog post I created on this subject, hopefully it's of use: https://www.theinformationlab.co.uk/2019/01/17/installing-r-packages-both-on-alteryx-designer-and-on...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your response. I have informed the server admin team to have a look.
