Open for Voting

Surrogate Key Transform - change to Row Counter and enable conditional counter reset

The Surrogate Key Transform is very useful to generate a running row counter across all processed rows within a data flow path. However, it is not useable when the counter needs to be reset when a change happens within a data set. E.g.: I need to create order line numbers and the counter needs to reset when the order number changes. Currently I'd have to do it via a script transform. It would be great if the Surrogate Key Transform was updated to allow this and as a bonus, to automatically sort the data based on the specified fields when the reset should occur. This way there's no need to use a separate data sort transform beforehand. Since the SKT functionality would be significantly expanded, maybe rename it to the more inclusive Row Counter Transform?