How to create count sequence

[Mostafa_Anwar]

Hi All,

How i can create a workflow to add count sequence for all customers in the Customer ID column based on each Event ID for all customers attend each event, So as per the highlighted cells in the attached output excel sheet for each EventID the customers id column will start the sequence from beginning.

Attached is the sample of data-set along with the output that looking for.

Thanks in advance!

Regards,

Mostafa

[MarqueeCrew]

@Mostafa_Anwar ,

 you can use my group by record id macro tool:

https://gallery.alteryx.com/#!app/CReW-GroupByRecordID/5e417bbf0462d70decb763a9  

cheers,

 mark

[Mostafa_Anwar]

Thanks @MarqueeCrew  for your respond, The provided WF creates number sequence for all rows, But what i am looking for that how the sequence start from 1 again in case of the number of EventID change, Please check the highlighted square you will notice the event id changed but the sequence count didn't start from the beginning.

[markcurry]

Hi @Mostafa_Anwar , the Crew macro should do the trick for you, you just need tick Event ID in the Grouping Fields. 

Then add the new RecordID to the Customer ID field with the formula ..[Customer ID] + "_" + ToString([RecordID])

 

[RobertOdera · Accepted solution]

Hi, @Mostafa_Anwar 

Try this.

Please mark as a solution + like, if it works for you.

The workflow is attached.

Cheers!

[RobertOdera]

Thanks @Mostafa_Anwar 

Glad to be of help.

Cheers!

[ll98]

Love the script -- What about if the fields are the same -- how do you do the avoid counting doubles .. In other words, if we 5 rows and two of the rows are the same value -- how do you avoid counting just 1 2 3 4 5 

instead of 1 2 3 4..  Basically if the field is related to James only and James is listed multiple times -- I just want  to count him as once.