Consecutive ID with variable changes

[KarenHM]

Hi Team , 

I need create an ID per every change in one variable sample:

JE	ID that I need
1141	1
1141	1
1141	1
1142	2
1142	2
1143	3
1143	3
1145	4
1145	4
1145	4
1145	4
1146	5
1146	5

I appreciate your help.

[DataNath · Accepted solution]

Hey @KarenHM, how does this look? Just need a Multi-Row Formula configured as shown (workbook attached):

[Amol_Telore · Accepted solution]

Hi @KarenHM 

You can create this ID using multi row formula tool. Below is the configuration of the same.

[IraWatt · Accepted solution]

Hey @KarenHM,

One simple way of doing this is with a summarize and record ID tool like this:

Any questions or issues please ask :)
HTH!
Ira

[binuacs · Accepted solution]

@KarenHM Onaway of doing this

[KarenHM]

Many thanks Alteryx Community. You are Rock !!!