This tutorial teaches you how to shape, transform, and manipulate data using the statement.
Syntax
The statement goes through one or several conditions and returns a value when the first condition is met.
After the clause, be sure to give it an alias to declare it as a newly created column.
The following query assigns fruit as a product category when the product is an apple, banana or cherry.
The following query assigns fruit as a product category when the product is an apple, banana or cherry and beverage when the product is a coffee.
The following query assigns to the product category:
Otherwise, assign a string saying "Can you identify the category?" for further identification of the product.
Next Lesson
Transforming with String-Text Functions