You are not logged in.
Thinks for Volker Brehm
you could use the function "Numeric.Sequence", the first parameter should be you key for the sequence ("Field 1").
The sequence is based on the key and not on the changed field. So if you add an row with field A at the end of your example the result would be 3.
Hope this helps.
How, in tMap, then I to load the field of a table with a numerical sequence which is initialized according to other fields'?
Here are what I want to obtain
Field 1 ! Sequence
A ! 1
A ! 2
B ! 1 <- starts again to 1 because field 1 changed from A to B
B ! 2
B ! 3
T ! 1 <- starts again to 1 (Field 1 changed from B to T)
U ! 1 <- starts again to 1 (Filed 1 changed from T to U)
Merci has all