Factor analysis: Different outputs of R Studio and R Tool

Hi,

When running the factanal function in the R tool and in R Studio I get completely different outputs.

The code I am running in Alteryx:

variables <- read.Alteryx("variables", mode="data.frame")
factormodel <- factanal(variables, factors=3, scores='regression', rotation='none')
x <- factormodel$scores

I am running it on the same dataset consisting of 8 normalised variables, and before using the function in the R tool I am making sure to explicitly convert these to floats, so I doubt it is a data type issue. I have attached extracts from the outputs.

Does anyone know what I am doing wrong in Alteryx?

Many thanks!

-Edit: I should probably add the format of my outputs:

RStudio: dataframe with dimensions: [Length_of_dataframe] x 3 --> what you would expect

R Tool: dataframe with dimensions: 1 x (3*[Length_of_dataframe]) --> for some reason it concatenated the results into one row vector

Alteryx_results.JPG

RStudio_results.JPG

Output

Predictive Analysis

R Tool

Accepted answers

helfenbeind

Thanks for your reply, Ben. I have found my error (I was pretty stupid and should have checked this earlier). The output of my R code is a matrix so I simply needed to convert it to a dataframe before passing it to the workflow.

Code is below (simply wrapping x inside data.frame()):

variables <- read.Alteryx("variables", mode="data.frame")
factormodel <- factanal(variables, factors=3, scores='regression', rotation='none')
x <- data.frame(factormodel$scores)
write.Alteryx(x, 1)

This gives me a dataframe with the factors as columns, exactly as in R Studio.

All comments

BenMoss

Can you please provide us with some sample data to test this against.

Ben

helfenbeind

Any dataset should work really. Example is attached.

TEST.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703