Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
This aggregate function calculates the number of rows of a specified table.
Syntax
COUNT_TABLE ( table )
Examples
[2] 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")