Sequencing from next instruction

[benjaviver]

Hi everybody, my really first message to the community :-).

I have this table (below):

I want to start with my first record because Seq is on 1.

My second column refer to the next ID (7220971 which is record 8). 

I want to tag my Seq field on record 8 at "2"

Then follow the next instruction  (7235626 = record 12) and put Seq at "3"

Until my nextmvmtinstrid = 0

See the willing result under the first table

Any idea how coud I get this instruction ? (Multi row formula ?)

Many thanks, 

Benjamin

	id	nextmvmtinstrid	Seq
1	7199358	7220971	1
2	7198006	0
3	7204625	0
4	7209609	0
5	7209610	7209609
6	7218330	0
7	7218331	7218330
8	7220971	7235626
9	7234285	0
10	7234292	7234285
11	7234705	7259671
12	7235626	7234705
13	7259670	0
14	7259671	7259670

1	7199358	7220971	1
2	7198006	0
3	7204625	0
4	7209609	0
5	7209610	7209609
6	7218330	0
7	7218331	7218330
8	7220971	7235626	2
9	7234285	0
10	7234292	7234285
11	7234705	7259671	4
12	7235626	7234705	3
13	7259670	0	6
14	7259671	7259670	5

[marcusblackhill · Accepted solution]

Hi @benjaviver !

Probably you will need to do a iterative macro, where you will organize them and put your seq number. If you need to return to the same original order of the data after you put you seq number, you just need to put a Record ID before begin you iterative macro and after the macro you sort again by ID.

If you don't know about iterative macros, here a example and some content to you can learn about.

https://help.alteryx.com/current/designer/iterative-macro

[benjaviver]

Many thanks for this solution & example :-).

It was a quick answer.