Consecutive ID with variable changes

Question

Hi Team ,

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

JE ID that I need 11411114111141111422114221143311433114541145411454114541146511465

I appreciate your help.

DataNath · Accepted Answer

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

Amol_Telore · Accepted Answer

Hi @KarenHM

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

IraWatt · Accepted Answer

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

binu_acs · Accepted Answer

@KarenHM Onaway of doing this