Sorting data - Data360_Analyze - 3.12

Data360 Analyze Server Help

Product
Data360 Analyze
Version
3.12
Language
English
Portfolio
Verify
Product family
Data360
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

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:

  1. In the data viewer, click the menu button in the column of the data that you want to sort.
  2. 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.

Note: The sort only applies to the selected column, and to the sample of data that is visible in the data viewer, i.e. up to the first 1000 records.

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.

Note: It is only possible to sort one column of data at a time.