Skip to main content
Syntax is a quite powerful way to reduce the amount of tools you need to use to get to your result. You can read much more about it in the Syntax section. In this lesson, we’ll dive into the different types of syntaxes and how to use them.

​
Exercise

We’re working with the Example_Dataset dataset and you want to get the result shown below. Our result contains five rows and we used three tools to get the result.
You are supposed to only use a single New Column tool to add the syntaxing column. Here’s logic of how we create it.
  1. Think of this in steps. You can perhaps start by creating each step with an individual New Column tool and then consolidate them at the end
  2. We using a conditional statement syntax to create the syntaxing column.
  3. We specify that the date_string should be a datetime value. Then we add the number of days in the int_col column to it.
  4. If it is larger than todays date (our date is Oct 6, 2025), then we multiply the simple_int column with the nulls_col if it is not null and one if it is null (maybe COALESCE?). If it is not larger than todays date, then we create a NULL value

​
Solution