Multi Row Formula...

[Raj_007]

Hi All,

Thanks for your time

Is Multi Row Formula tool same as the Row_Number() over (Partition by col1 order by col2) in SQL server

I do not have anything in the group by of MultiRow Formula.. just want to confirm it is same as row number so that i can push it to the SQL Select

[OllieClarke]

Hi @Raj_007 

In order to replicate that SQL query, you'd need to first sort your data by col2, then in your multi-row formula tool, create a new column called rowNum,

Group by col1 (which acts as the partition), and then use the formula [row-1:rowNum]+1

There's more info on the tool here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...

Hope that helps,

Ollie