Exit from a transformer

[xcasals]

Hello again,

I'm trying to 'exit' from a Transformer. I mean, the Transformer is generating rows from a counter. I want to say, when Counter = 1200 then exit (or stop generating data) from this transformer.

Thank you

[Amos.Rosmarin]

Put your counter in a stage variable and create a constraint stageVar < 1200

if you are using @INROWNUM remamber the if the transformer does not have an input link, the first @INROWNUM is 0 !!

HTH
Amos

[neena]

You cannot end your job with transformer.
There shold be atlease one output is eeded for transformer.
Then use a stage variable and @INROWNUM condition to come out of transformer
Thanks

[chulett]

Ahh... but you can start a job with a Transformer for the purpose of generating data. This is what the OP is doing.

[vmcburney]

You do have an @OUTROWNUM so I think you could just use a constraint @OUTROWNUM < 1201.

[chulett]

Exactly. Even starts counting from 1.