Hello, new to Alteryx here. Having some issues with the R tool
Attached is a sample dataset and workflow.
The attached code works great in Rstudio.
For some reason it fails in Alteryx.
Not using anything fancy, just base R.
My goal: perform Wilcox test on each variable (column) in my dataset against the "group" variable/column, then output a database of p-values (listed in a column).
When I use the alteryx R tool, the p-values result as "0" with an error that reads: "The display value was rounded to 6 decimal places for clarity." Outside of alteryx, with the same dataset, it works fine...
Here is the code:
data <- read.Alteryx("#1", mode="data.frame")
out <- apply(data[-1], 2, function(x) wilcox.test(x, data$group))
p <- sapply(out, function(x) {
p <- x$p.value
n <- outer(rownames(p), colnames(p), paste, sep='v')
p <- as.vector(p)
names(p) <- n
p
})
p <-data.frame(keyName=names(p), value=p, row.names=NULL)
write.Alteryx(p, 1)
Any help would be very much appreciated!
