| Table of Contents | ||||
|---|---|---|---|---|
|
...
How does it work in the search window?
Select Create column in the search window toolbar, then select the Conditional operation. You need to specify three arguments:
Argument | Description | Data type |
|---|---|---|
if mandatory | Boolean field that will be used as the base of your condition. | boolean |
then mandatory | The value you specify here will be returned if the value of the Boolean column is true. | Any |
else mandatory | The value you specify here will be returned if the value of the Boolean column is false. | Same than or compatible with the data type selected in then (for example, integer and float are compatible types) |
The data type of the output values depends on the types selected in the then and else arguments.
Example
In the demo.ecommerce.data table, we want to add a column that shows the string Client error responses when the values in our statusCode column are 4xx or 5xx codes, and Succesful response when they are 2xx. To do it, we will create a new column using the Conditional operation but first, we need to create a Boolean column that detects client error responses.
...
Step 2: Create a new column using the Conditional operation
Select Create column on the query toolbar, then select Conditional as the operation. Fill the arguments as follows, and enter a name for the column (responseType):
...
ifthenelse(boolean, value1_true, value2_false)
Example
You can copy the following LINQ script and try the above example on the demo.ecommerce.data table.
| Code Block |
|---|
from demo.ecommerce.data
select statusCode > 400 as statusCode_type,
ifthenelse(statusCode_type, "Client error response", "Successful response") as responseType |