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
Solved! Go to Solution.
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
Happy to help!