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

Top ten products before and after cleaning

Rank products by total Amount using the raw file as delivered (numeric Amount only, codes as typed), then after full cleaning. How many products are in the top ten both times?
Expected
Two ranked lists of ten and the overlap count · Ranked bar chart
Tables
FactTransformationEvents, DimProduct · columns
  • FactTransformationEvents
  • DimProduct
  • ProductCode
  • Amount

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