Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
Transfer columns to the R server, execute a script and which has the same length as the input columns.
Syntax
RCALL(table.column AS input_name(, table.column AS input_name)*, r_script)
- table.column: Column(s) to be transferred to the R server
- input_name: Name under which the column will be accessible in the R script
- r_script: R script to be called
RCALL expects the R script to return a column which has the same length as the input columns.
Examples
In this example a column is multiplied by 2 via an R script.
Query
Column1
RCALL("Table1"."Column1" AS STRC, 'STRC * 2')
Column2
"Table1"."Column1"
Execute RCALL for an alternative way to calculate the QNORM.
Query
Column1
RCALL ("Table1"."Column1" AS column1, 'qnorm(column1)')
Input
Table1
Column1 : FLOAT |
---|
1.0E-7 |
1.0E-5 |
0.001 |
0.05 |
0.15 |
0.25 |
0.35 |
0.45 |
0.55 |
0.65 |
0.75 |
0.85 |
0.95 |
0.999 |
0.99999 |
0.9999999 |
Output
Result
Column1 : FLOAT |
---|
-5.199337582192817 |
-4.2648907939228256 |
-3.090232306167813 |
-1.6448536269514726 |
-1.0364333894937894 |
-0.6744897501960817 |
-0.3853204664075676 |
-0.125661346855074 |
0.12566134685507413 |
0.3853204664075676 |
0.6744897501960817 |
1.0364333894937894 |
1.6448536269514715 |
3.090232306167813 |
4.26489079392384 |
5.199337582290662 |