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.
Adding 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.