Creating Macros in R and Importing them in Alteryx

[AIPH123]

Hi All,

Sorry if this question does not make sense. Am trying to explore Alteryx more.

Is there an option in Alteryx to create our own tools as macros? I.,e writing code in R, convert the code to macro and import as a tool into Alteryx.

If so, can some one share one example for my reference. 

Br,

Anil

[PhilipMannering · Accepted solution]

There is a way of creating macros. If you want to create R based macros then you'll want to use the R tool (make sure you have R tools installed).

The process will usually look like,

1. Macro Input

2. R Tool

3. Macro Output

Most of the predictive tools are R-based macros, so take a peek by right clicking on the tool and clicking Open Macro

I've attached an example that calculates chi-squared...whether correctly or incorrectly I couldn't tell you. I created it a while ago...

This is also quite useful: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/A-Cheat-Sheet-of-Functions-to-Use-i...

[Dynamomo]

There is also a video on how to build an R macro - https://community.alteryx.com/t5/Videos/Building-a-R-Macro/td-p/46567

which may be helpful.