When to Use
- Concatenate first and last name into full_name.
- Compute a value (e.g. total = quantity * price).
- Add a constant (e.g. source_system = ‘erp’).
- Extract part of a value (e.g. year from date).
Example
Addfull_name as first_name + ' ' + last_name:
| first_name | last_name | full_name |
|---|---|---|
| John | Doe | John Doe |
| Jane | Smith | Jane Smith |