This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hello,
see screen-shot below:
Question
using the ADF dataflow, how is it possible to get to the result in green from the data in orange colour ?
Thank you
Hey,
below blog might help:
https://eax360.com/find-duplicate-records-with-azure-data-factory-same-source-file/
Hi, thanks for the link but it does not seem to be similar to what I am after.
notice in my example there is a column 'uom' which is different and I would like to have the columns for that related record to be on one line rather than multiple.
Thank you
Hey,
The above blog is just a base case wherein your key would be UOM column.
You need to follow the below steps:
stackoverflow.com/questions/66424058/how-do-i-add-a-partitioned-row-number-to-azure-data-factory
2) Use filter transformation to filter out rownbr>1
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-filter
