Use of Analytic Query Step
How to get the 2nd row from the same column & add the 1st & 2nd rows value & so on.
Scenario : In column Value contain sample values like, 11, 32,45,67,76,... & need to read the 2nd value & add with 1st value & store the result & so on.
Solution:
- For this scenario, we can use the Analytic Query step, it's needed sorted data to get the correct result.
Please find the attached sample workflow for reference.