Partition over by with ROWNUM

[EmilBras]

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

[MarqueeCrew]

Can you please clarify the problem?

Thanks,

Mark

[EmilBras]

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?

[EmilBras · Accepted solution]

I have found the solution:

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

[azim]

What is the best way to deal this query in Alteryx ?

CASE
WHEN CUST_COUNT='0'
THEN ROW_NUMBER() Over(partition by coulumn names )
ELSE ROW_NUMBER() Over(partition by ADDRESS ORDER BY AGE DESC) END AS HH

[KaneG]

Hi @azim,

Best option would be to post this as a new question in future so that more people see it. Your question depends whether you are working In-DB or not. The previous question related to In-DB processing. And if so, then you can probably get your answer from above. If you are not working with In_DB tools, then I would need an example to know definitely, however you should be able to do it with summarise and transpose tools.

Kane