Trying to read RData file into Alteryx

creily

Hello,

I am tying to read R data files (.RData) into Alteryx. I use this code in the R tool:

write.Alteryx(readRDS("C:/Users/user/Desktop/Alteryx Data/July 2018, Single Cell Exp/ALL_8_SAMPLES/Riley_1904_170.RData"), 1)

This error gets returned

Error: R (1): Error in readRDS("C:/Users/user/Desktop/Alteryx Data/July 2018, Single Cell Exp/ALL_8_SAMPLES/Riley_1904_170.RData") :
Info: R (1):   unknown input format
Info: R (1): Calls: write.Alteryx -> readRDS
Error: R (1): Execution halted
Error: R (1): The R.exe exit code (1) indicated an error.

What am I missing? Thanks for the help!

DavidxL

The initial R error is saying that the RData contains an S4 class - meaning it's probably a complex object and not a simple table. Can you check what the object structure looks like in R/RStudio?

obj <- readRDS(...)

str(obj)

After that you have to figure out which part of the object you want to import to Alteryx and/or convert it to a dataframe if necessary.

 

For example:

table <- obj@dat

write.Alteryx(as.data.frame(table),1)

It's possible that the RData contains a more complicated structure so you'll have to determine what/how to extract it.