Convert stack to merge

Options
N_JAYANTH
N_JAYANTH Registered Posts: 11 ✭✭✭✭

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?

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    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.
Setup Info
    Tags
      Help me…