Alteryx designer inDB multi row formula.

[sgokul6]

Is there any way to right a multi row formula while working with indb data, in alteryx designer?

[afv2688]

Hello @sgokul6 ,

the first thing that comes to my mind would be functions LAG and LEAD from SQL. They do work in the indb formula tool.

you can read about them here:

https://learnsql.com/blog/difference-between-two-rows-in-sql/

Regards

[simonaubert_bd]

@sgokul6Hello. You would have to use windowing functions as mentioned previously. There is currently no multi-row tool for Alteryx but here is the idea :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Multi-row-formula-indb-windowing/idi-p/10294...

Best regards,

Simon