I am trying to increment the values of one column in a table by 1. I tried to write a datafunction using R script as.
result <- Number+[1]
where result is the outparameter and Number is one of the columns in my table but I am getting following error when trying to insert.
TIBCO Spotfire Statistics Services returned an error: 'parse(text = script) : unexpected symbol in "{};{result <-Number"'.
at Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.<ExecuteFunction>d__12.MoveNext()
at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()
Please suggest where I am going wrong. I am trying to learn about Datafunctions