Picking first 11 records in a Transformer

[Suman]

I have records coming like this into a transformer:

Id1 Id2 Field
123 1 1
123 2 2
123 3 3
123 4 4
.................
................
234 1 1
234 2 2
..................
..................

I need first 11 records based on Id1 and Id2. Is there any way to do it in
transformer.

Thanks

[chulett]

I'm sure there is, but you should give a better explanation of what 'based on Id1 and Id2' means to get more accurate advice.

This would typically involve stage variables, doing a little 'group change detection' dance and constraining the output to 11 max per group.

Actually, that's a Server answer because you posted in the Server forum, but just noticed you marked this as Parallel. Perhaps there's a better approach in a PX job?

[DSguru2B]

Are you using a Basic Transformer. If yes then Craigs solution would work. Actually it would work even with the Parallel Transformer because all that needs to be done is the change detention and restricting the output to 11.

[kumar_s]

If it is PX and if you need first 11n distinct records based on the two field, you have many approach, like using remove duplicate stage in conjunction with transformer, or sort stage with the KeyValueChange option.
But you need to give out more information of what is you exactly need in?