Summation in transformer

veera24 · Post by **veera24** » Thu Jan 08, 2009 10:30 am

Hi all,
Is there any function to sum up the value in the transformer stage itself?or should i go with Aggregator stage alone for summation?

Your time would be highly appreciated.

Thanks in advance,
Veera.....

chulett · Post by **chulett** » Thu Jan 08, 2009 10:33 am

Stage variable using "+". SDK routine "RowProcRunningTotal". Or an Aggregator stage.

veera24 · Post by **veera24** » Mon Jan 12, 2009 12:50 am

chulett wrote:Stage variable using "+". SDK routine "RowProcRunningTotal". Or an Aggregator stage. ...

Craig,
I can view this routine in the palette but not in the column derivation.What shall i do?Should i compile the routine before?

Your time would be highly appreciated.

Thanks in advance,
veera

chulett · Post by **chulett** » Mon Jan 12, 2009 8:41 am

It's already compiled. Sorry, but I don't undestand what "but not in the column derivation" means. Do you mean via the ellipsis (...)?

veera24 · Post by **veera24** » Mon Jan 12, 2009 8:51 am

chulett wrote:It's already compiled. Sorry, but I don't undestand what "but not in the column derivation" means. Do you mean via the ellipsis (...)? ...

No. When i tried to use that function in the column derivation of the transformer, its not being showed. Could you explain,why?

chulett · Post by **chulett** » Mon Jan 12, 2009 8:58 am

Again, you have not explained what "not being showed" means. Transforms trump routines so you need to look under DS Transform rather than DS Routine, is that your issue?

veera24 · Post by **veera24** » Mon Jan 12, 2009 9:02 am

chulett wrote:Again, you have not explained what "not being showed" means. Transforms trump routines so you need to look under DS Transform rather than DS Routine, is that your issue? ...

Yes craig. I'm really very sorry. The routine was not being displayed in the derivation. As you said its available in DSTransforms.

Thanks for your valuable time.

chulett · Post by **chulett** » Mon Jan 12, 2009 9:12 am

Nothing to be sorry about, part of the learning experience of transforms versus routines. I'm sure there's a "full Wurlod" on the subject here somewhere.

veera24 · Post by **veera24** » Mon Jan 12, 2009 9:16 am

chulett wrote:Nothing to be sorry about, part of the learning experience of transforms versus routines. I'm sure there's a "full Wurlod" on the subject here somewhere. ...

Ofcourse craig. Anyways, Thanks for your kindful reply. I'm happy about that now.

chulett · Post by **chulett** » Mon Jan 12, 2009 9:26 am

A little old but still perfectly valid. Only odd thing to know about the Oliver Archives is they are records from a "list server" and thus all emails, so start from the bottom and read up.

viewtopic.php?t=82321

Just to add: some people reply at the top, some at the bottom. Some properly quote what they are replying to, some don't. At little messy but good information there.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 12, 2009 1:37 pm

RowProcRunningTotal is a transform function (which is to be found in Routines), not a Transform.

chulett · Post by **chulett** » Mon Jan 12, 2009 1:40 pm

Granted, but the ellipses/picker will only show it in the DS Transform section because there is one (a transform) defined over that routine, hence the discussion re: it 'not showing up'. The vast majority of sdk routines fall into that category.