1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Data Studio Recipes
      1. Aggregation Recipe
      2. Change Type Recipe
      3. Data Quality Recipe
      4. Filter Recipe
      5. Formula Recipe
      6. Fuzzy Join Recipe
      7. Join Recipe
      8. Python Recipe
      9. Rename Recipe
      10. Sample Recipe
      11. Save MV Recipee
      12. Select Recipe
      13. Sort Recipe
      14. Split Recipe
      15. SQL Recipe
      16. Union Recipe
      17. Unpivot Recipe
    7. Public API
    8. Security
    9. SQL Interface
    10. Visualizations
    11. Other
  8. Integrations
  9. Data applications
  10. Releases

References → Sort Recipe

The sort tool is essential for sorting data results based on one or more columns, enabling users to organize data in a specific order, ascending or descending. This sorting capability is crucial for data analysis, reporting, and ensuring the information is presented meaningfully and comprehensibly.

Configuration

ConfigurationDescription
Recipe NameA freeform name of how a user would like to name a recipe
InputSelect a previously constructed recipe to process
Sorting OrderAscending -
  ●   Numeric - Low to high
  ●   String - A to Z, then a to z
  ●   Date - Oldest to most recent Descending -
  ●   Numeric - Low to high
  ●   String - z to a, then Z to A
  ●   Date - Most recent to oldest
ColumnsSelect which columns to sort. Multiple columns can be selected.
Note

The order columns selected reflect the order in which the columns are sorted. In 2024.4, it’s a known issue that the front end does not reflect the column selection order, but the backend will be sorted correctly.