# Case (if/else)

This common method utilizes if-then-else logic, assigning a result when the corresponding condition evaluates to true, otherwise assigning the final ("else") result –> [learn more](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#case)

```sql
CASE
  WHEN @condition THEN @result
  [ ... ]
  [ ELSE @else_result ]
  END
```

#### Return type

dynamic (input-dependent)

#### Parameters

| Name           | Type                                                                                                                                                                           | Allowed values                                                                           | Required | Placeholder (in UI)   |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------------- | -------- | --------------------- |
| `@condition`   | (nested) conditions – like those used in a [Filter](https://docs.redivis.com/reference/workflows/step-filter#step-structure)                                                   | any [Redivis type](https://docs.redivis.com/reference/datasets/variables#variable-types) | true     | -                     |
| `@result`      | [variable](https://docs.redivis.com/reference/projects/transforms/parameters#variable) or [literal](https://docs.redivis.com/reference/projects/transforms/parameters#literal) | any [Redivis type](https://docs.redivis.com/reference/datasets/variables#variable-types) | true     | *(Variable or value)* |
| `@else_result` | [variable](https://docs.redivis.com/reference/projects/transforms/parameters#variable) or [literal](https://docs.redivis.com/reference/projects/transforms/parameters#literal) | any [Redivis type](https://docs.redivis.com/reference/datasets/variables#variable-types) | true     | *(Variable or value)* |