Sorting a column and finding quartiles
You can sort values in a column so that values are displayed in ascending or descending order. Rows containing FNF in the sorted column are not included in the resultant table. Therefore, it is possible that the resultant table contains fewer rows than before the sort. For more information about FNF, see Working with a table containing FNF.
After you sort a column, you can determine the quartiles for the values in the column.
Sorting values in a column
Follow these steps to sort a column:
- In the column drop-down menu, select Sort. A pop-up is displayed for you to specify whether to sort in ascending or descending order.
If the data type of the column is String and Xcalar Design decides that most of the values in the column are numbers, it displays the Sort Suggestion dialog box. Depending on the desired method of sorting, click Alphabetically or Numerically.NOTE: If you select Numerically, the data type of the column is changed to integer.
The column header includes an arrow indicating the column is sorted. The following screenshot shows a part of the Distance_integer column that is sorted.
Sorting values in multiple columns
Follow these steps to sort multiple columns:
- To sort a particular column first, display the column options from that column. Then select Sort to display the pop-up.
- Click Advanced … in the pop-up to display the Sort panel. The column name is displayed in the Sort panel.
Select another column (by clicking anywhere in the column) as the second column to be sorted. Repeat this step for each additional column that you want to sort.
To deselect a column, click the column again.
The column names are listed in the Sort panel in the same order as you select the columns. Also, each column header is associated with a number (for example, 1, 2, and so on), indicating the order in which the columns will be sorted. In the following screenshot, the DayOfWeek column is selected first, followed by the AirTime column.
- In the Sort panel, for each selected column, specify whether the sort is in ascending or descending order.
- Click SORT.
How quartile values are affected by sorting a string column
If a column being sorted contains FNF (field not found), the FNF rows are removed from the resultant table. (For more information about FNF, see Sorting a table by a column containing FNF.) If sorting a string column gives you a choice of sorting numerically or alphabetically, your choice affects how many rows will contain FNF after the sort. As a result, you might get different quartile values from the same column, depending on whether the column is sorted numerically or alphabetically.
Finding quartiles in a column
After you sort a column, follow these steps to determine the quartiles for the values in the column: