Skip to main content
Version: 0.22.2

Flip

Flip lets you flip a column's contents by a delimiter, such as a dash. For example, a column containing "B-064" would flip to "064-B".

Format

Flip uses a single utterance: Flip the column <column name> on the delimiter <delimiter>.

Parameters

Flip uses two parameters:

  • column name (required). The name of the column you’d like to flip.
  • delimiter (required). The delimiter you want to use to flip the column. This can be a number, letter, or symbol. A space (“ “) is the default delimiter.

Output

If a column is successfully flipped, a success message appears in the chat history and a new dataset with the flipped column is created. Otherwise, an error message appears.

Examples

Values in the Cabin column are often listed as “level-room number,” such as "A-23". To flip the Cabin column, enter Flip the column Cabin on the delimiter -.