Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Tip

Tip: Use the Column Browser panel to quickly locate and select columns for display or other actions. See Column Browser Panel.

Automatically update

Unlock the column's data type. For more information, see Change Column Data Type

Rename

Rename the column.

For more information on column name requirements, see Rename Columns.

...

Info

NOTE: Hide/Show commands do not create transformation steps. Hidden columns still exist in the output.

Info

NOTE: When a column is hidden from a dataset, it is hidden for all users. You should check the column browser for hidden columns in shared datasets.

Sort

Sort: Sort the values in the column by ascending or descending value. This command does not apply to some data types.

...

 When a column is sorted in ascending order, the bottom values are mismatched and null values, in that order. These values appear at the top of the column when sorted in descending order.

For more information, see Sort Rows.

Edit with formula

Modify the column values based on a formula that you input. For more information, see Transform Builder.

...

Tip

Tip: The transformation-by-example feature can be used in place of standardization or extraction transformations and may be simpler to use.

Info

NOTE: This feature may need to be enabled in your environment.

See See Create Column by Example.

...

You can copy and paste columns and column values into other areas of your dataset. For more information, see Copy and Paste Columns.

D s also
inCQLtrue
label((label = "transformation_ui") OR (label = "transform_ui") OR (label = "column_ui"))