Skip to main content

Symon.AI help center

Case

Abstract

Label your data in a specific way using the Case tool.

Adds a label to data according to logical tests.

To add labels to your data:

  1. Pick a name for the new column.

  2. Select the default value. if the logical test fails, the default value is used instead.

  3. Select any number of values. If the logical test succeeds, then one of these values is used.

You can set as many logical tests as you'd like, but there can be only 1 default value.

When to use this tool

Use when you want to label your data in a specific way.

Error messaging

The Case tool can find the following errors in your data set:

  • Syntax error: An unknown function is occurring, or the function cannot parse due to a special character, or a missing bracket.

  • Invalid argument error: The tool detects that the argument is invalid due to a wrong data type.

  • Too many arguments error: The tool detects that there are too many arguments.

  • Missing arguments error: The tool detects that there are arguments missing from the range of the number of arguments.

  • Unsupported data type error: The tool detects an unsupported data type. The Formula tool only accepts number, boolean, string, and date data types.