Generate the sequence without using row id transformation

[Radhesh]

Hi All,

Im new to alteryx and I want to know whether we can generate the sequence without using the row id transformation. Any help would be great!!!

Thanks in advance

[DataBlender]

Hi @Radhesh

Are you able to provide a bit more information as to what you're trying to do exactly (perhaps an example)?

Generate Rows may help depending on your scenario.

[MarqueeCrew · Accepted solution]

Hi @Radhesh,

Sorry, but I'm confused by your ask.  I think that you don't want to use the RecordID tool.  You can use a multi-row formula and create a sequence number by looking at row-1:sequence and adding 1.  With this approach, you can create sequence numbers and use a GROUP BY configuration so that the sequence could be by person, day or other data variable.

Cheers,

Mark

[Radhesh]

Thanks a lot Mark. Your solution really helped