Skip to main content

Varicent ELT Assistant

Conditional

Use the Conditional tool to answer a question about your data, returning a TRUE or FALSE response in a new column. The Conditional tool determines if data passes a logical test.

For example, you want to see if all of your sellers' base pay was greater than or less than their quarterly commission earnings. At a glance, you can see if the response is true or false for each seller.

Input

The Conditional tool requires one data set.

Configuration

Use the following configuration options to configure the Configuration tool.

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the search bar, search for Conditional. Click + Add tool.

    Tip

    You can also find the Conditional tool in the Calculate section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, under New column name, enter a name for the new column.

  8. Under the If all drop-down, click to select either the If all or If any condition.

    • If all: All conditions are met, the tool returns a True answer. If none of the conditions are met, it returns a False answer.

    • If any: Any conditions are met, the tool returns a True response. If none of the conditions are met, it returns a False response.

  9. Select the columns to use for the conditions from your dataset, and select the operator:

    • Equal

    • Not equal

    • Less than

    • Less than or equal

    • Greater than

    • Greater than or equal

    • Starts with

    • Ends with

    • Contains

    • Not contains

    • Is null

    • Is not null

  10. Click + to optionally add another condition.

  11. Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.