Work with Numeric.sequence()

[stephbzr]

Hello,

I can't find a solution for a problem I have. I have tried many things in the tMap, but without success. I show you the goal and what I want to achieve with an example. 

First, I need a column "HIST_INDICATOR" that when a date is found for the first time in the dataset, the indicator is 0, then 1 for the next times (or if the date already exists in the database). This condition applies only to rows of type "070" because these are the ones that will be integrated into a table in the database. There are 3 types (070, 223 and 255 because the other types will be integrated in another table). Here is my data set (reduced for the example) : 

 

Here is what I use in tMap to answer my first need

 

 

Here is what I get, and if I filter by "070", I have the desired indicator

 

However, I can't get the 070 indicator to follow for the other lines (until the next 070), here is what I would like to get 

 

[Jfoster1657625676]

A number sequence is a list of numbers that are linked by a rule. If you work out the rule, you can work out the next numbers in the sequence.