| Change type | Description |
|---|---|
| Updated in version 3.16.0 | Capability to sort multiple columns simultaneously and customize the sort order and direction |
You can sort the data within a column in the data viewer to help you quickly organize and find the data that you want.
You can then add this sorted data back into your data flow as a pre-configured Sort node, see Adding sorted data from the data viewer to your data flow.
To apply a sort:
- In the data viewer, click the menu button in the column of the data that you want to sort.
- Select Sort.
The sort options available depend on the type of the data in the selected column.
- For String data sets you can sort by A-Z or Z-A.
- For Date, Time and DateTime data sets, you can sort by Oldest to Newest or Newest to Oldest.
- For Number data sets, you can sort by Smallest to Largest or Largest to Smallest.
When a column is sorted, an arrow on a blue background indicating the direction of the sort is shown below the column menu. You can click the sort arrow to reverse the sort order.
Generally, each row in the data viewer is alternately striped. When you apply a sort to a column of data in the data viewer, the row striping changes in line with each value change to enable you to easily spot changes in your data.
Sorting Multiple Columns
You can also sort multiple columns simultaneously.
To sort multiple columns:
- Hold down the Ctrl button and left-click the column header. Each time you click, the column is added to the sort. The sort order is given by the number you see on the sort indicator.
- From the context menu, select Sort Multiple Columns. The context menu is also available by right-clicking the tab header.
- When you select the option, a dialog opens where you can edit the sort. You can add, remove, change order, and change sort direction.
- You can also access the dialog by right-clicking a sort indicator in the column header.
Add sorted data from the data viewer to your data flow
If you have sorted data in the data viewer, you can then transfer this information directly to your data flow as a pre-configured node.
After you have sorted the data, from the menu in the top right corner of the data viewer, select Sort.
A pre-configured Sort node is then automatically added to your data flow, connected to the output pin of the node outputting the sorted data.