Option for R Datasets via Input/Output tools

[santiago_restrepo]

The capability to input/output R Datasets via the input/output tools, together with all the other data formats as well (like csv, Excel, SAS, SPSS, etc).

[BenG]

Hi Santiago,

Do you have an example of what an R dataset would look like?  Datasets that I've found seem to be mostly csv files, but maybe there's a format within an R process that stores them differently?

Thanks,

Ben

[santiago_restrepo]

Hi Ben.

I have an example, but there is not an option to load files to this forum - or at least I could not figure it out  :-)  
The file extensions is .Rdata.

There is a way to currently import the R-dataset using the R code icon, but the flexibility and user experience would be a lot better, if this option was available in the Input/Output tools.

Here is a sample of the code that goes in:
load("%Engine.WorkflowDirectory%RTest2.RData")
write.Alteryx(Rrest, 1)

The name of the file is Rtest2.Dtata, and both the data file and the workbook need to be saved in the same location.


Thanks,

Santiago

[BenG]

Thanks Santiago,

I will discuss with our Advanced Analytics group and see what kind of effort it would be to support this format.
 

Ben

[Saraja]

In the same context, will it be possible to input/output the Stata (Statistical software just like R, SAS and SPSS) format dataset. The file extension for Stata is *.dta I have not seen any on in the Alteryx community mentioned about Stata so far. This software is extensively used in statistical modeling and data management in the area of economics and research. Thanks Saraja

[ARich]

Hi All,

We don't have immediate plans to implement this, but please continue to star if you'd like to see!

Best,

Alex