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
Solved! Go to Solution.
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)
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.
@NeilR - How do I handle null values in the .rdata file with this approach?
Are you having a problem? Null values seem to be coming through correctly for me...
Doesn't look like the attachment came through.
Still not seeing anything. One thing I'd suggest is debugging in RStudio, making sure you can get it all the way to a data frame.