Table Name

table nameThis Analytics Edge wizard lets you save the current table for reference later in the macro, such as with appending or comparing tables. You can also switch back to that table to perform multiple calculations from the same data. You can even use the values in the table as predefined ranges in other functions.

Assign a name to the current table – This allows you to lock the current table in memory and assign it a name for reference later in the macro. It is typically used with one of the comparison or combination functions (Append, Combine, Compare, Match, Update).

Switch to a previously named table – This allows you to switch the focus to a previously named table (as above). It is typically used to go back to an intermediate point in a macro and perform a different analysis on the same source data, such as calculating percentage growth and the calculating difference.

Assign range names to each column of the current table – Analytics Edge can sometimes use defined ranges instead of fixed values. This is typically used to read configuration options or selections from a worksheet, and then to customize the analytics based on the values, such as filtering by a date range or value from a specific cell. Each column in the current table is saved as a range, using the name of the column.