Spline Tool Output

[j_brzezinski]

What is  content of the spline tool output object?  I would like to extract lists of variables and coefficiects, r_square, and fitted values for additional analyses and visualizing actual vs fitted values (which are not in the reports output).

[ChadM · Accepted solution]

For the Spline Tool, try dropping in a R Tool, then enter the following script:

the.model = read.Alteryx("#1")
the.model = unserializeObject(as.character(the.model$Object[1]))

## Extracting Coefficients ##
coefficients.names = row.names(the.model$coefficients)
the.model.coefficients = data.frame("Term" = coefficients.names, "Value" = as.vector(the.model$coefficients), row.names = NULL)
write.Alteryx(the.model.coefficients, nOutput = 1)

## Extracting R Squared ##
the.model.summary = data.frame("R.Squared" = the.model$rsq)
write.Alteryx(the.model.summary, nOutput = 2)

## Extracting Fitted Values ##
the.model.fitted.values = data.frame("Fitted.Values" = as.vector(the.model$fitted.values))
write.Alteryx(the.mode?l.fitted.values, nOutput = 3) 

This will output your coefficients to output 1, the R Squared value to output 2, and the Fitted Values to output 3.  Thanks!