Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
see screen-shot below:
using the ADF dataflow, how is it possible to get to the result in green from the data in orange colour ?
below blog might help:
The above blog is just a base case wherein your key would be UOM column.
You need to follow the below steps:
2) Use filter transformation to filter out rownbr>1