Convert stack to merge

N_JAYANTH
Level 2
Convert stack to merge

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?

0 Kudos
1 Reply
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.
0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku