Pentaho - Increment when a value changes

Question

I want to increment a value by 1 every time a value changes.

For example there may be 3 rows with the value 098290-IFS. Those rows will all have a value of 1 for the increment, but when the value changes to say, 017393-IFS, the value will increment to 2, and so on.

What transformation would I use to do this?

Answer 1

You can use the next step Add value fields changing sequence. This adds a number when the value changes, keep in mind that you may have to sort the flow to achieve the result you expect, you cant look this enter link description here,Regards