Record count in Transformer

ady · Post by **ady** » Wed Nov 22, 2006 8:34 am

How can i get the record count of a specific input column in a transformer
along with the other transformations.

And can i take out the max value of the Record Count. I do not want to use a aggregator for this.

chulett · Post by **chulett** » Wed Nov 22, 2006 8:42 am

After job, DSGetLinkInfo with DSJ.LINKROWCOUNT as the InfoType.

thumsup9 · Post by **thumsup9** » Wed Nov 22, 2006 8:46 am

RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)

and for the second part you can use a stage variable to store current and previous values.If the current value is greater than the Previous value then store the currect value to the stage variable.

ady · Post by **ady** » Wed Nov 22, 2006 11:53 am

[quote="thumsup9"]RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
quote]

What should i substitute for each of these "hJob", "StageName", "LinkName", "DSJ.LINKROWCOUNT"

DSguru2B · Post by **DSguru2B** » Wed Nov 22, 2006 12:51 pm

Read in the help for DSGetLinkInfo().