Have you experience like this
- you get input data from table
- you transform the data
- you put the output data and the result is duplicate, even when the input data is not duplicate?
- Check your query on input, make sure you there only 1 order by, not 2 nor 3. Or you order the data on next step
try it