Page 1 of 1
Record count in Transformer
Posted: Wed Nov 22, 2006 8:34 am
by ady
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.
Posted: Wed Nov 22, 2006 8:42 am
by chulett
After job, DSGetLinkInfo with DSJ.LINKROWCOUNT as the InfoType.
Posted: Wed Nov 22, 2006 8:46 am
by thumsup9
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.
Posted: Wed Nov 22, 2006 11:53 am
by ady
[quote="thumsup9"]RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
quote]
What should i substitute for each of these "hJob", "StageName", "LinkName", "DSJ.LINKROWCOUNT"
Posted: Wed Nov 22, 2006 12:51 pm
by DSguru2B
Read in the help for DSGetLinkInfo().