Working with sequences

[stephbzr]

Hello, 

Here is what I needed to do in a previous task : for each row where the entity is 070 (because these rows are stored in a different table from the others), put 0 when the date (column REP_DATRO) is found for the first time otherwise 1. 

Here is the code to have the HIST_INDICATOR column : 

 

 

Here is what I want to do now in a new column :

 

It's quite difficult, I don't have a deep knowledge of existing methods in JAVA to help me accomplish this. Here is what I have tried so far 

 

 

[Anonymous]

Hi

I don't understand why the HIST_INDICATOR column has empty value in your second image, with the expression shown in the first image, there should be 1 or 0?

 

Regards

Shong