Check if a Table in Data Source is empty

To check whether a table in data source is empty or not, use IsEmpty

IsEmpty(tableName)

This is equivalent to CountRows(tableName)=0

We cannot use CountRows() directly on data source as it generally gives Delegation warning (Depends on the Connector)

If IsEmpty(tableName) returns true, this indicates that your Data Source table has no rows.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s