NOTE: This plugin is an old and open source version and is not the same as R script executor, which is available from Pentaho.
R Script Plugin supports two use cases:
- Execute R code for every row in the table
- Execute R code for whole table and aggregate the result
Pentaho/R Integration Plugin can be downloaded here: Downloads
Two demostrate the usage we develop the following transformation:
Schematically these two use cases are shown on the figures below.
Case 1
|
Case 2
|
The inputs and outputs and R code for two use cases are demonstrated on the image below.
In the first case we calculate the sum for every row, for example, c=a+b=1+2=3.
In the second case we calculate the average of vector a=(1, 1.56, 3) and vector b=(2, 1.57, 4) and then calculate the sum: c=mean(a) + mean(b) = 1.85333 + 2.52333 = 4.37666