Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
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")
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")