Page 1 of 1
how to use max function in transformer without aggregator
Posted: Thu Apr 23, 2009 12:05 am
by monaz
Hi can anyone guide me how to use max function in the stage variable of the transformer.
I dont want to use aggregator for this i wanted to know is it possible to implement in the transformer stage
example:-if input is
1 m
1 m
1 o
1n
Output i am loking for
1 mmon
Posted: Thu Apr 23, 2009 12:27 am
by ray.wurlod
Nowhere in what you have described is there any need for any kind of Max() function. You are performing a vertical pivot.
It is possible to implement what you have described in Transformer stage (ideally with an upstream Sort stage generating a Key Change column and a downstream Remove Duplicates stage.
Re: how to use max function in transformer without aggregato
Posted: Thu Apr 23, 2009 12:34 am
by Pagadrai
Hi,
Is there any specific reason why you dont want to use aggregator stage?
You can defnitely use a transfomer stage to find out the max value.
But the data must be sorted before and sent to the transfomer in a sequential order.
There are some resolved posts where similar logic has been discussed.
Try and let us know.
Posted: Thu Apr 23, 2009 8:05 am
by chulett
As noted, the example shows a need for a
pivot, not a max() or any kind of aggregation.