row count in dataset

kamesh · Post by **kamesh** » Thu Feb 19, 2004 6:06 am

Hi
Pls can any one help me how to find the row count in data set.if need to use transformer or any other stage is also ok with me
Thanks
kamesh

Teej · Post by **Teej** » Thu Feb 19, 2004 6:59 am

kamesh wrote:Hi
Pls can any one help me how to find the row count in data set.if need to use transformer or any other stage is also ok with me
Thanks
kamesh

You could use the counter with the Stage Variable. You can build a buildop to count it. You could observe the link's count on a simple dataset -> copy job. You could use the Dataset Administrator (Designer & Director) to do the simple math. The list goes on...

What do you want to use the count for?

-T.J.

praj · Post by **praj** » Thu Feb 19, 2004 7:27 am

"You could use the counter with the Stage Variable." ...seems to be most tempting and easy solution. But this will blow up as u add configuration file to ur job(which u will). Just add 2*2 or 4*4 config file and c the result.

bigpoppa · Post by **bigpoppa** » Fri Feb 20, 2004 7:17 pm

Do OUTROWNUM and INROWNUM work in PX's transform? If so, that would be the way to get a row count. For a total record count of a dataset, use a 'dsrecords'.

DSXchange