This module will discuss the capabilities to calculate new fields and transform data from within the table editor view of the Data manager. This includes: the ability to bin data into categorical ranges, parse data from a single field into multiple fields, and replace multiple values with a single consistent value or a null value.
Learning Objectives:
- Apply data profiling cards, including bucket, split, replace, & order
- Generate new calculated fields with expressions
- Convert a 'short-wide' to a 'tall-thin' table layout using the unpivot tool