How to tweak Col Rank() to give consecutive numbers when using byCol
I use Col Rank() to count runs:Col Rank( :DateTime, :WaferID, <<Tie( "minimum" ) )
Each run may have multiple rows, which I can only separate by DateTime, so instead of writing long if statements, I used this formula. The only thing that I don't like is the following. Let's say I have three rows generated per run, then my RunID column would look like: 111444777 and so on. I get where it comes from....