Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5
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
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 |