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

Description

This aggregate function calculates the number of rows of a specified table.

Syntax

COUNT_TABLE ( table )

Examples


Count the number of rows of a single table:

Query
Column1
COUNT_TABLE("Table1")
Input
Table1
column1 : STRINGcolumn2 : INT
'A'
1
'A'
1
'A'
3
'B'
1
'B'
2
Output
Result
Column1 : INT
5



Count the number of rows of two joined tables. The output is grouped by column1. Within each group, COUNT_TABLE counts the number of rows originating from the requested table:

Query
Column1
"Table1"."column1"
Column2
COUNT_TABLE("Table1")
Column3
COUNT_TABLE("Table2")
Input
Table1
column1 : STRINGcolumn2 : INT
'A'
1
'A'
1
'A'
3
'B'
1
'B'
2
Table2
column1 : STRINGcolumn3 : STRING
'A''x'
'B''y'

Foreign Keys
Table1.column1Table2.column1
Output
Result
Column1 : STRINGColumn2 : INTColumn3 : INT
'A'
3
1
'B'
2
1


  • No labels