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)
Solved! Go to Solution.
Figured it out! Configuration of the Macro Input to process a test input data source cleaned up the issue!