Get Row Count

Retrieves the number of rows in the table.

Overview

This procedure retrieves the number of rows in the table. You can use it to see if data was loaded correctly, check if a table is empty, or track changes in the amount of data over time.

Input Concepts

Concept	Type	Description	Default	Required
table	table	The table whose row count is to be retrieved.	No default	Yes

Output Concepts

Concept	Description
row count	The number of rows in the table.

Examples

1. Getting the Row Count of a Sample Table

In this example, the table refers to the following table, which can be generated using the create a sample table procedure:

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

Automation

get the table's row count

Results

3