What would be a good way of adding a new “Sequential count based on case” column to a table that counts upwards each row based on how many times the same-same value occurs in another Data_Field?
For example, something like the Count column in this screenshot:
Just noticed that the result of the transform says ‘0 rows totalled’. I have fixed that now. Fix will be in the next release. Please report anything like this you spot!
Thanks for pointing out the “Total” transform.
Exactly what I need (if it worked…)
I was also trying to use OFFSET in combination with an IF transform
to flag when one set of records ends and the next begins
however the IF statement always incorrectly returns zero.
@Free_World_Maps
The reason this isn’t working is because you currently can’t use column variables (such as $(Offset)) for the IF part of the transform. Only for the THEN or ELSE. Other people have been caught out by this and we hope to add this feature soon.