Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q032 Hard

Category standardisation bridge

Total the clean Amount in SAR by DimProduct.Category exactly as spelled, then again after mapping every variant to its canonical name. How many raw labels collapse into the canonical set, and what is the largest canonical total?
Expected
Raw label, canonical label, total; before and after counts · Matrix
Tables
FactTransformationEvents, DimProduct · columns
  • FactTransformationEvents
  • DimProduct
  • ProductCode
  • Category
  • Amount
Topics
Data Cleaning

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in