Find and Select Columns by Property or Statistic

[#1]

If your data table contains many columns, it can be easy to forget where things are. Find columns that contain a column property or certain statistics with the Columns Viewer. Results in the Columns Viewer are linked to the source data table, which means that results are automatically selected in the data table and in launch windows. If you have many similar columns, you can find and select columns based on a statistic, such as the biggest standard deviation.

To use Columns Viewer:

1. Open the data table.
2. Select Cols > Columns Viewer.
3. Select the columns that you want to search.
4. To show summary statistics for the selected columns, click Show Summary. For continuous columns, you can also select Show Quartiles.
5. To find columns with specific column properties:
1. Click Find Columns with Properties.
2. Select the properties that you want to find.
3. Click OK.
4. (Optional) Sort the list by right-clicking in the results and selecting Sort by Column.

In the data table, the results are selected. You can now run any platform and the columns are pre-selected in the launch window.

Show Summary Statistics with Columns Viewer