Error: R (12): Error in (function (..., row.names = NULL, check.rows = FALSE, check.names

[wcamarg3]

Hi all,

I am using a developer tool with R code, but it always return the same error of "Error: R (12): Error in (function (..., row.names = NULL, check.rows = FALSE, check.names = TRUE, :"

This code runs on R well. 

On Alteryx I runned line per line, and I know that the error appears only when I insert the last line "write.Alteryx(variance_wilcox, 1)"

Below is the code:

############################################################

#Teste de Hipótes Não Normal

data <- read.Alteryx("#1")

#Verificar se o campo P-value está preenchido ou não
#Se for diferente de vazio está preenchido

if (data$p.value != '') {
Week1 <- read.Alteryx("#2")
"&"
Week2 <- read.Alteryx("#3")
}

# TESTE DE MANN WHITNEY (Variance Test for Non-Normal)

Week1_data <- Week1$Wk1_feature_value
Week2_data <- Week2$Wk2_feature_value

#define vectors
week1 <- c(Week1_data)
week2 <- c(Week2_data)

merge(cbind(week1, X=1:length(week1)),
cbind(week2, X=1:length(week2)), all.y =T)[-1]

# TESTE DE MANN WHITNEY (Variance Test for Non-Normal)
variance_wilcox <- wilcox.test(week1,week2, alternative='two.sided', conf.level=.95)

write.Alteryx(variance_wilcox, 1)

############################################################

Does anyone knows what I can do?

[wcamarg3]

Hi all. I attached my workflow with the data to see if someone can help me.

The problem is to output the test result on R tool. 

It is on this line: write.Alteryx(variance_wilcox, 1)

Please. If anyone can help me. I have no more idea of what I can do.

Many thanks

[wcamarg3 · Accepted solution]

Hi all,

I suceed to find the solution.

1st step --> Transform my variable to tibble:

variance_wilcox<- wilcox.test(week1,week2, alternative='two.sided', conf.level=.95)

variance_test <- tibble(variance_wilcox)

2nd step -->

After done it, another error message appeared, related to 'WriteYXDBStreaming'. For this, the topic on link: Solved: 'WriteYXDBStreaming' Error using R node - Alteryx Community.

Then I finsihed like:

variance_test[] <- lapply(variance_test, as.character)

write.Alteryx(variance_test, 1)

Many thanks,

Wilson