Query Editor/Add Custom Column /From previous row

[RJ]

Hi

I need to add a new column at the query editor stage where the row number is from the row above the current row

Unsure how this is done

Thanks

[RJ · Accepted solution]

ok this was quite easy to do

Step 1 Add column / add index column (this gives a column with numbers starting with a selected number +1 for each row)

Step 2 Add colum / Index + 1 (index column number + 1)

Step 3 Merge Index column with step 2 column. Expand and delete column not required.