In Alteryx, the unique tool indicates if a record is unique or is a duplicate by grouping and sorting specific fields. It takes the first record on a group as the unique one, and the rest go to duplicate.
In Dataiku, the window tool is more appropriate than the distinct recipe to do it, because it will capture the whole table. The ideal would be to combine the window tool with the Rank filter and setting up like Rank=1 with a post filter.
Let us know if this helped you to get started with Dataiku !
