Any alternate way to read previous row data

[Sashikumar]

Mulit row formula is not available in ALTERYX CLOUD. 
To read previous ROW-1 or ROW+1 records , is there any alternate solution available to achieve this function by using FORMULA TOOL?

[AkimasaKajitani · Accepted solution]

Hi @Sashikumar ,

If you only want to read previous/after row, there is a solution.

1. Add the row ID by RowID tool

2. Add minus/plus 1 to RowID into new field (e.g. RowID2)

3. Join 1 and 2

Workflow

Input

 

Output

 

Please copy and paste the sampewf.txt(Ctrl + v) on Designer Cloud.

[Sashikumar]

Thanks for your suggestion. 👏