Assigning unique ID to each date that are assigned to an ID.

[stj1120]

Hi all,

In the dataset there is a unique ID column and each ID has two date fields. I tried to generate the dates that are between these two dates for each ID. For each date I'm trying to generate unique number to it. I'm able to get the unique number to each date right from the start date to end date of each ID. But, it starts with 0,1,2,3. My result should start with 1,2,3 etc. 

You can see it in the below screenshot. 

Please check the attached workflow and help me with the right logic.

Thank you.

Best regards,

teja.

[alexnajm · Accepted solution]

if [ID]= [Row-1:ID] then [Row-1:New Field]+1 else [Row-1:New Field]+1
endif