Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Contents:


 

This section describes how values are sorted within  Cloud Dataprep by TRIFACTA® INC.. Sorting can be applied through the following mechanisms:

  • Clicking a column header in a workspace table, such as the Flows, Library, or Jobs pages.

  • Applying the ARRAYSORT function to an array. For more information, see ARRAYSORT Function.

NOTE: Following listings represent sorting in ascending order. Descending order sorting is in the reverse of the listings below.


General Sort Order

For any column, sorting is performed in the following order:

  1. Sorting based on data type
  2. Mismatched values
  3. Null/empty values

Sort Order for Strings

Since all values are valid for String data type, this sort order represents the most common representation for sort order.

  1. Sorting based on data type:
    1. Numeric values (low value to high value)
    2. Whitespace
    3. Special characters
    4. Alphabetical
      1. Case-insensitive
      2. Accented characters (ä) are below unaccented character (a)
  2. Mismatched values
  3. Null/empty values

Sort Order for Integers and Decimals

For Integers and Decimals, sorting happens in the following order:

  1. Sorting based on data type:
    1. Numeric values (low value to high value)
  2. Mismatched values
  3. Null/empty values

  • No labels

This page has no comments.