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.
SOLVED

Newbie question: R tool runs in workflow but does not work as a Macro

PAFlores
6 - Meteoroid

Newbie question/issue.

 

I have a "bit" of R that I use to prep data to generate some box and whisker charts that runs in the R Tool but when I try to turn it into a macro that I can reuse it returns a rather ambiguous error (Error: Quartile (4): R-QuartileBody: Error in `[.data.frame`(myList[[i]], c("Measurement")) : ).  Attached is a data file that can be used to test the script and what I am seeing.

 

Below is the body of the R.

 

Can anyone tell me what I am missing?  Or where I have gone wrong? 

 

Thanks in advance for the assistance!

 

Paul

 

--------------------------------------------------------------------

 

My.DataSet<-read.Alteryx("#1", mode="data.frame")
#
myList<-list()
myList=split(My.DataSet,f=My.DataSet$TesterSN)
#
DataList<-list()
for (i in 1:length(myList)){
tmplist<-list('numeric')
tmplist<-myList[[i]][c('Measurement')]
medianValue<-median(as.numeric(as.character(tmplist[[c('Measurement')]])),na.rm=TRUE)
minValue<-min(as.numeric(as.character(tmplist[[c('Measurement')]])),na.rm=TRUE)
maxValue<-max(as.numeric(as.character(tmplist[[c('Measurement')]])),na.rm=TRUE)
StdDevValue<-sd(as.numeric(as.character(tmplist[[c('Measurement')]])),na.rm=TRUE)
quartile<-quantile(as.numeric(as.character(tmplist[[c('Measurement')]])), na.rm=TRUE)
medianValue<-as.data.frame(medianValue)
mlinValue<-as.data.frame(minValue)
maxValue<-as.data.frame(maxValue)
StdDevValue<-as.data.frame(StdDevValue)
Q1=quartile[1]
Q2=quartile[2]
Q3=quartile[3]
Q4=quartile[4]
Q5=quartile[5]
CalcValues<-data.frame()
CalcValues<-data.frame(Q1,Q2,Q3,Q4,Q5,medianValue,minValue, maxValue,StdDevValue)
DataList[[i]]<-CalcValues
}
ResultSet=do.call(rbind, DataList)

write.Alteryx(ResultSet, 1)



 

 

1 REPLY 1
PAFlores
6 - Meteoroid

Figured it out!  Configuration of the Macro Input to process a test input data source cleaned up the issue!

Labels