Partition over by with ROWNUM

I want a ROWNUM in een OVER PARTITION BY.

For the LAG and LEAD functions it work just fine, but for the ROWNUM it just gives me errors.

I have a workflow greated with IN-DATABASE

Preparation

Expression

Accepted answers

I have found the solution:

ROW_NUMBER() OVER (PARTITION BY "PATIENT","TRAJECT" ORDER BY "PATIENT")

Can you please clarify the problem?

Thanks,

Mark

Dear MarqueeCrew,

Thanks for the reactions. Have made a example of what the results must be.

All this i has to be in IN-DATABASE workflow.

Extra Info, I also have Business Objects and within the report it is easy to make those formula's

Is there a list of examples of comen formula's in Alteryx?