SAVE TABLELIST command

Saves a list of all tables in an Analytics project to an Analytics table or a CSV file.

Syntax

SAVE TABLELIST {FILE|TABLE} TO {table_name|file_name}

Parameters

Name Description

FILE | TABLE
  • FILE saves the table list to a CSV file (.csv)
  • TABLE saves the table list to an Analytics table

TO table_name | file_name

The location to save the table list:

  • table_name the name of the output Analytics table and the associated .fil file when using TABLE

    The .fil file extension is used by default and does not need to be specified. The table is saved in the same folder as the Analytics project, and cannot be saved in any other folder.

    Note

    Analytics table names are limited to 64 alphanumeric characters. The name can include the underscore character ( _ ), but no other special characters, or any spaces. The name cannot start with a number.

  • file_name the name of the .csv file when using FILE

    The .csv file extension is used by default and does not need to be specified. You can specify an absolute or relative path to save the CSV file in an existing folder other than the folder containing the Analytics project. If you specify a relative path, it is relative to the Analytics working directory.

You must specify values as quoted strings if they contain any spaces.

Examples

Creating a new table

You create a new table in the Analytics project called Table_list_complete:

SAVE TABLELIST TABLE TO Table_list_complete

Creating a CSV file

You create a new CSV file in the C:\ACL Data folder called Table_list_complete.csv:

SAVE TABLELIST FILE TO "C:\ACL Data\Table_list_complete"

Remarks

Output columns

The output Analytics table or CSV file contains three columns:

  • table_name the name of the Analytics table layout
  • type an indication whether the Analytics table is a local table or a server table
  • Data_file_Path the full path to the source data file