Pro exercise
Map month spellings to one code
A month column was typed as Mar, March, 03 or 3. Map every approved spelling to a two-digit month code, quarantine what isn't a month, and total units per month.
- mappings
- controlled vocabulary
- aggregation
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.