how to use max function in transformer without aggregator

[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

[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.

[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.

[chulett]

As noted, the example shows a need for a pivot, not a max() or any kind of aggregation.