How to use the median function

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

av686165
Posts: 9
Joined: Fri Feb 14, 2020 5:53 am

How to use the median function

Postby av686165 » Fri Feb 21, 2020 8:57 am

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.

bartonv
Posts: 145
Joined: Wed May 03, 2017 12:10 pm

Re: How to use the median function

Postby bartonv » Fri Feb 21, 2020 2:28 pm

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,
Attachments
median.grf
(4.47 KiB) Downloaded 54 times
---
Vladimir Barton
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron