Forum Discussion
Calling a column parameter in a custom function
Anonymous ,
What does the error message say? How about change the parameter with other names like "param1", "param2"?
Regards,
Jimmy Tao
The error is: object 'column' can't be found, even though I do select a column for that parameter when I invoke the function
Which is why I figured I had a formatting error when I would try to reference that parameter. This is my code when I tried a different parameter name instead of 'column', unfortunately I got the same error message:
fnr = [
Arima.model=
(dataset as table,param1 as list) as table=>
let
RScript=R.Execute("
library(forecast)
library(tseries)
Values<-param1
ValuesTs<-ts(Values,start=c(1999,1),frequency=4,end=c(2019,4))
fit<-auto.arima(ValuesTs,stepwise=FALSE,approximation=FALSE)
df<-data.frame(forecast(fit,h=16))
df['Years']<-seq(2020,2035,1)
",[dataset=dataset]),
output=RScript
in
output
],