Convert stack to merge

N_JAYANTH

I have a dataiku dataset like the following

I want to merge these rows based on "PATNO" into a single row. Note, there are different groups of PATNO, So I need to iterate over them too. Is there any way to do this?

Clément_Stenac

The question is, what rules do you want apply when there are several rows for a given PATNO ? Probably, the "Group" recipe does what you want. For example, you could group by PATNO and take the MAX of all other columns.

We are working on a "merge duplicates" recipe for a future release of DSS.