How to create count sequence

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

Output.xlsx

DataSet.xlsx

Workflow

Accepted answers

RobertOdera

Hi, @Mostafa_Anwar

Try this.

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

The workflow is attached.

Cheers!

For_Mostafa_Anwar.yxmd

All comments

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.

RobertOdera

Hi, @Mostafa_Anwar

Try this.

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

The workflow is attached.

Cheers!

For_Mostafa_Anwar.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703