Simple way to perform Partition by in Alteryx

[ramkumarmaruthai]

Hi All, 

Is there a simple way to perform SQL partition by in Alteryx without using Summarize and Join tools

Please let me know thanks. My expectation is below

[IraWatt · Accepted solution]

Hey @ramkumarmaruthai,

Sure you can use the Multi Row Formula Tool:

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

One thing also to not would be you will want to order your dates as the Multi Row Formula Tool works top down.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[ramkumarmaruthai]

Thanks a lot IraWatt 😊

[IraWatt]

No worries @ramkumarmaruthai 😄 have a good one !