Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!

The RowCount(table name) will give you this.
The out-of-the-box Data Expiration report will show you row counts and  the last updated date for every table.  The report can be found in a Cost Transparency project under Data Quality / Summary (Data Quality - Summary) / Data Expiration tab.

Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!

Great! Thank you so much @Rene Norskov :)

The RowCount(table name) will give you this.
The out-of-the-box Data Expiration report will show you row counts and  the last updated date for every table.  The report can be found in a Cost Transparency project under Data Quality / Summary (Data Quality - Summary) / Data Expiration tab.

Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!

Follow up question:

I am trying to get row counts of several tables into a column in 1 table. I have a column which contains the table names, lets say the column name is 'TableName'. When I use the formula RowCount(TableName), it shows an error and does not return any values. I believe the RowCount() function expects the actual table name as the argument and not another column which contains the table name.

Is there a way to achieve this?

Great! Thank you so much @Rene Norskov :)

The RowCount(table name) will give you this.
The out-of-the-box Data Expiration report will show you row counts and  the last updated date for every table.  The report can be found in a Cost Transparency project under Data Quality / Summary (Data Quality - Summary) / Data Expiration tab.

Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!

You can use the Eval() function to achieve this.

However, your calculation times can be affected if you use Eval() so it is be to avoid it.  You may consider using the out-of-the-box report mentioned above.

Follow up question:

I am trying to get row counts of several tables into a column in 1 table. I have a column which contains the table names, lets say the column name is 'TableName'. When I use the formula RowCount(TableName), it shows an error and does not return any values. I believe the RowCount() function expects the actual table name as the argument and not another column which contains the table name.

Is there a way to achieve this?

Great! Thank you so much @Rene Norskov :)

The RowCount(table name) will give you this.
The out-of-the-box Data Expiration report will show you row counts and  the last updated date for every table.  The report can be found in a Cost Transparency project under Data Quality / Summary (Data Quality - Summary) / Data Expiration tab.

Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!

Thanks again @Rene Norskov :)
I will take that into consideration.

However, since I am working in Bill of IT and not CT, I cannot see the data quality summary report. Is there an equivalent report in Bill of IT too?

You can use the Eval() function to achieve this.

However, your calculation times can be affected if you use Eval() so it is be to avoid it.  You may consider using the out-of-the-box report mentioned above.

Follow up question:

I am trying to get row counts of several tables into a column in 1 table. I have a column which contains the table names, lets say the column name is 'TableName'. When I use the formula RowCount(TableName), it shows an error and does not return any values. I believe the RowCount() function expects the actual table name as the argument and not another column which contains the table name.

Is there a way to achieve this?

Great! Thank you so much @Rene Norskov :)

The RowCount(table name) will give you this.
The out-of-the-box Data Expiration report will show you row counts and  the last updated date for every table.  The report can be found in a Cost Transparency project under Data Quality / Summary (Data Quality - Summary) / Data Expiration tab.

Hi,

Just like how we use the function TableInfo("Last Updated", "Table Name") to get the last updated date for the table, is there a way to get the row count of the table too?

Basically, I am trying to create a report which shows the last updated and row count for a set of tables.

Thanks in advance!