Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

RCALL

Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

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

[1] 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"

Input

Output

Column1 : INT

0

1

2

3

4

Result

Column1 : FLOAT

Column2 : INT

0.0

0

2.0

1

4.0

2

6.0

3

8.0

4

[2] Execute RCALL for an alternative way to calculate the QNORM.

Query

Column1

RCALL ("Table1"."Column1" AS column1, 'qnorm(column1)')

Input

Output

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

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