Table management

You use table management tasks to manage reference tables and the internal tables that are generated during analysis. For example, you can use table management tasks to open, export, or delete tables and to view the table content, table size or other metadata about the table.

You create a reference table to save criteria for a column and then use that criteria elsewhere. Reference tables can be exported to other projects in the suite or to external systems. You might want to create a reference table to reuse information about a column. For example, when you evaluate the frequency distribution of a column that was created during a column analysis job, you might mark some values in column A as invalid. You can then create a reference table that contains all of the invalid values and apply those values to column B so that you do not need to perform the same task on the invalid values in column B.

Tables that are generated during analysis include frequency distribution tables that are created during column analysis and rule output tables that are created during the execution of data rules. These tables contain information about your data that you might want to view to learn more about how the data was handled during analysis. You can also export the tables to a file to share the information with other users or processes.

Note: Frequency distribution tables can be very large and take up a lot of space. You can delete a frequency distribution to reduce the amount of space that is used on a system. However, if you delete a frequency distribution, you lose the results from the column analysis job that created it and you will not be able to run subsequent analyses that use the frequency distribution as input, such as primary key analysis and baseline analysis.