how to get the N th row

nareshketepalli · Post by **nareshketepalli** » Thu Mar 17, 2011 3:08 am

how to get the N th row in data stage?

Regards,

MT · Post by MT » Thu Mar 17, 2011 3:30 am

Hi,

with a transformer!

Short question - short answer

nareshketepalli · Post by **nareshketepalli** » Thu Mar 17, 2011 3:36 am

can u tel me the procedure

MT · Post by MT » Thu Mar 17, 2011 6:19 am

Yes.

Use stage variables and build a counter like
svCounter + 1 => svCounter
and the you build a condition to your output link svCounter = N

chulett · Post by **chulett** » Thu Mar 17, 2011 6:39 am

There's also the @INROWNUM and @OUTROWNUM system variables that can be leveraged. All solutions need to take your paritioning into account as you would be capturing the Nth row per node otherwise.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 17, 2011 4:03 pm

Head stage (N rows) followed by Tail stage (1 row). There's always more than one way. Note that, in parallel execution, any of these methods will give you the Nth row on each node.

nareshketepalli · Post by **nareshketepalli** » Thu Mar 17, 2011 10:40 pm

Thankyou