Table Sort.pdf

From Array Suite Wiki
(Redirected from SortRows.txt)

Sort Table by rows or by columns

Overview

Array Studio contains two ways to sort the table, sort by rows and sort by columns. They can be accessed by Table|Rows|Sort Rows or Table|Columns|Sort Columns.

SortData3.png SortData4.png

Input Data Requirements

Both sort by rows and sort by columns command work on Table objects; however, sort by row will not work on Design Tables and Annotation tables, as these tables have fixed rows.

Step 1: Select source table

SelectData0.png

The user will first be asked to choose the table on which to sort rows/columns:

Step 2: How to Sort the Table

For sort by rows, the user will be presented with the "Sort Rows" window, where multiple sorting options can be entered, including the option to sort Ascending or Descending. The user can sort first on one column, then add additional columns (to up to 4) for additional sorting.

SortData1.png

For sort by columns, the user will be presented with the "Sort Columns" window, where multiple sorting options can be entered, including the option to sort Ascending or Descending. The user can sort first on one row, then add additional rows (to up to 4) for additional sorting. This works on “Table” objects, including Design Tables and Annotation tables.

SortData2.png


Output Results

A new table will be created in the Solution Explorer.

Table SelectList SolutionExplorerFinal.png

The output table will have the rows or columns sorted as defined.

Related Articles

EnvelopeLarge2.png