How to use the median function

CloverDX Platform
1

Hi Team,

I am unable to use the “Median” function which is present in “Aggregate” transformers.
I have 3 records present in 3 different cell. I am unable to perform “Median” as values are present in row-wise.

Example: A 1,2,3

The median function should fetch the output as 2.please advise.

2

Hi there,
to be able to use the median function, it is necessary to normalize the data first before they flow into Aggregate. I have attached a simple example of how this can be done using the Normalizer component.
Best regards,