R data files (.RDA, .RDS *.RData)

I'm an R user and checking out the functionality of Aletryx. I see that there is very good R integration -- but, as I review the documentation, I am not seeing that Alteryx allows for R data files to be read using the input tool. Am I overlooking something?

Thanks,

Brian

Preparation

R Tool

Accepted answers

NeilR

You're right that the Input Data tool can't read these types of files in. In some cases it makes sense (an RData file can actually contain multiple files so doesn't always lend itself to tabular data). But you can read these files in using the R tool...

write.Alteryx(readRDS("C:/Users/nryan/Desktop/temp/xy.RData"), 1)

All comments

NeilR

write.Alteryx(readRDS("C:/Users/nryan/Desktop/temp/xy.RData"), 1)

michael_treadwell

It doesn't read these but you could easily create your own macro using the R tool and a File Browse interface tool that would allow you to input RDS data frames. See the attached.

Edit:

@NeilR beat me to it.

read_rds.yxmc

andrew_cook

@NeilR - How do I handle null values in the .rdata file with this approach?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703