Sequential Numbers on Field Change with Start Number

[Feastie]

Hi,

I hope you experts can assist (I know you can!). I'm pretty new to Alteryx and need a little help.

I require a sequential numbering system based on two field changes, which I can achieve by using a multi row tool but, I need it to start from a specific point from an input text tool [Table A]. i.e. I am given a starting reference of 123456, which is the ref for the first group and the subsequent groups will just be +1.

From the input text tool [Table A], how do I place the start ref into the first Ref: cell of the second table [Table B]? Thanks in advance for any help.

Table A                            Table B

[alexnajm · Accepted solution]

Join tool, joining on Record Position, would work well if you just want it on the first record! This is probably the option I'd do - workflow attached

Otherwise an Append Fields tool would work well to add it to every row 

[Feastie]

I never thought about joining on record position and then using Union to bring the non-matches back in. Elegant, efficient and a fab solution. Thanks! @alexnajm

[alexnajm]

Happy to help!