Door 22 Table statistics

Welcome to door 22. Today's door will be another short one, but no less importantly. Because today I would like to talk to you about the FM.TableStatistics function. This function provides you with table statistics for your tables.

In this function, we first specify the file name and then the table name. Our call then looks like this:

Set Variable [ $Statistics ; Value: MBS( "FM.TableStatistics"; Get(FileName); "Movie" ) ]
Show Custom Dialog [ "Table statistics from the tabl…" ; $Statistics ]

And this is the result:

We can extract some information, such as the number of records, how many fields we have with text and numbers, and much more. The plugin will walk over all records and count fields with various data types and how many empty fields there are. It skips global and formula fields. We sum up the length of all text in text fields as well as the text content of all fields. This function can take a long time for huge tables with millions of records.

I hope this function will be useful to you in analyzing your data.