Skip to main content

Celonis Product Documentation

COLUMN_TYPE
Description

COLUMN_TYPE returns the type of a data model column.

COLUMN_TYPE returns a STRING constant indicating the type of a data model column. Temporary columns, such as expressions that return a column, are not supported.

Depending on the data type of the column, COLUMN_TYPE returns either "INT", "FLOAT", "STRING", or "DATE".

Syntax
 COLUMN_TYPE ( "TABLE"."COLUMN" )
Examples

[1]

Query

Column1

         COLUMN_TYPE ( "EMPLOYEE"."ID" )
        

Input

Output

EMPLOYEE

ID : int

FIRST_NAME : string

LAST_NAME : string

HIRE_DATE : date

SALARY : float

1

'John'

'Smith'

Tue Feb 01 2022 00:00:00.000

15000.0

2

'Max'

'Mustermann'

Thu Dec 01 2022 00:00:00.000

12500.0

3

'Jane'

'Doe'

Sat Jul 01 2023 00:00:00.000

16000.0

Result

Column1 : string

'INT'

[2]

Query

Column1

         COLUMN_TYPE ( "EMPLOYEE"."HIRE_DATE" )
        

Input

Output

EMPLOYEE

ID : int

FIRST_NAME : string

LAST_NAME : string

HIRE_DATE : date

SALARY : float

1

'John'

'Smith'

Tue Feb 01 2022 00:00:00.000

15000.0

2

'Max'

'Mustermann'

Thu Dec 01 2022 00:00:00.000

12500.0

3

'Jane'

'Doe'

Sat Jul 01 2023 00:00:00.000

16000.0

Result

Column1 : string

'DATE'

[3]

Although INDEX_ORDER returns an INT column, it is not a column from the data model itself, but a computed column, so the column type cannot be determined and an error is returned. Most other PQL functions that return columns are also not supported.

Query

Column1

         COLUMN_TYPE ( INDEX_ORDER ( "EMPLOYEE"."SALARY" ) )
        

Input

Output

EMPLOYEE

ID : int

FIRST_NAME : string

LAST_NAME : string

HIRE_DATE : date

SALARY : float

1

'John'

'Smith'

Tue Feb 01 2022 00:00:00.000

15000.0

2

'Max'

'Mustermann'

Thu Dec 01 2022 00:00:00.000

12500.0

3

'Jane'

'Doe'

Sat Jul 01 2023 00:00:00.000

16000.0

Warning

COLUMN_TYPE: The argument must evaluate to a data model column.