CONTENT WARNING
This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com
| SortTextColumn |
This function sorts the page alphabetically or numerically according to the designated text column.
Syntax:SortTextColumn, caption, sortOrder, alphaNumeric Parameters:caption - the text column caption to be sorted. sortOrder - {ascending, descending } for setting the order of the sorting. alphaNumeric - {alphabetic, numeric } for setting the type of sorting. Examples:SortTextColumn,Runner,desc,numer This example sorts all the rows in your data based on the value in a text column labelled 'Runner' in a descending, numerical order. Note that the parameters may be shortened. |
Reference
- Functional Index
- AddAggregates
- AddBaseline
- AddData
- AddPage
- AssignCellFormat
- AssignColumnCSS
- AssignWordsToValues
- AssignWordsToValuesSelectedColumns
- AutoPopulateBaselines
- ChangeAlertTo, Axis
- ChangeAlertTo, CellValue
- ChangeAlertTo, None
- ChangeAlertTo, RelativeCell
- ChangeLabelCaption
- ChangePageProperties2
- ChangeTextInTextColumn
- ChangeValuesAboveBelowAggregation
- ChangeValuesPercents
- ChangeValuesToNTile
- ChangeValuesToRank
- ChangeValuesValues
- ClearOldPages
- ClearSelection
- Combine
- CombineDuplicates
- CombineSimilar / ByIndex
- Compare
- CompareSimilar
- ConcatenatePagesWith
- ConcatenateTextColumns
- ConvertAlertsToData
- CopyDataToTextColumns
- CreateTextColumnFromDateColumn
- DeleteTextColumn
- DistributeCellCollection
- Extract
- FilterByValue
- FilterGlobally
- GetCaption
- GetCountsOfValues
- HidePage
- HidePagesExcept
- ImportData
- ImportDataNoHeader
- InvertSelection
- JoinTwoPagesByMatchingRowLabel
- KeepSelected
- MathOperation
- MathOperationOnTwoPositions
- MoveColumns
- MoveColumnValuesToPages
- MoveRowLabelsToPages
- MoveRows
- MoveTextColumnValuesToPages
- NewRowLabel
- NewStartingPoint
- NewTextColumnName
- PageCaption / PageDescription / PageDescriptionAppend
- PageNumericFormat
- ProjectProperties
- Prompt
- PromptForPage
- Query, Captions
- Query, Command / CommandAppend
- Query, CommandTimeout
- Query, Roles
- Query, RowLabel
- Query, Run, ODBC / Oracle / SQL / JDBC
- Query, RunSave, ODBC / Oracle / SQL / JDBC
- Query, TextColumnNames
- RemoveDate
- RemovePage
- RemoveSelected
- RemoveTextColumnsAndDataColumns
- RepeatDataColumnNames
- RepeatingCalculation
- RepeatTextColumnNames
- RepeatTextColumnValues
- Reverse
- RollingPeriods
- RunScript
- SaveAsProject
- SavePageToCSV
- SavePageToCSVPivot
- SavePageToNOD
- SavePageToXMLCrosstab
- SearchAndSelect
- Select, Cell / Unselect, Cell
- Select, Page
- Select,Row/Column Unselect,Row/Column
- SelectByCaptions
- SelectBySpecificPositions
- SelectRange / UnselectRange
- SetCultureString
- SetMath
- SetTupleValue
- ShowAsNumberStandardDeviations
- ShowPage
- Sort
- SortByDate
- SortColumnLabel
- SortCustom
- SortRowLabel
- SortSelected
- SortTextColumn
- SplitTextColumn
- Swap
- SwapCellValues
- SwapTextColumnWithColumn / ByIndex
- SwapTextColumnWithRowLabel / ByIndex
- Test