J
Jeff Commaroto
The ability to clean data using conditional functions that create custom dimensions or alter data within the dimensions themselves. This is a standard feature in many competing platforms.
Example Conditional Functions:
IF
  • Evaluates the condition of each successive WHEN clause and returns the first result where the condition is true; any remaining WHEN and ELSE clauses are not evaluated. If all conditions are false or NULL, returns else_result if present; if not present, returns NULL.
  • Syntax
IF(condition, true_result, false_result)
CASE
  • Compares input_expression to expression_to_match of each successive WHEN clause and returns the first result where this comparison returns true.
Syntax
CASE
WHEN condition THEN result
[WHEN condition THEN result]
[...]
[ELSE else_result]
END
Then any kind of string functions like concatenate, upper, lower, title, etc.