Capture of Median - DataFlux

[Ronny_Dsouza]

Hi All,

As part of a Business Rule, there is a requirement  of using the Median as part of the condition, one of the approach we are trying to take is to see if its part of any of the profiling node which then can be used in conjunction of the Data Monitoring node in a data job.

Hence the following query

1) Is there any manner wherein I can capture the Median Statistic that is outputted as part of a Profiling activity, if Not

2) Any one who has used the expression node to generate the median.

Regard

Ronny

[skillman]

Ronny,

There is not a straightforward way to do this with just one expression. I have attached a screenshot of a job that will calculate the median:

Input:

Output:

The other variables are ones that were created to assist in the median calculation.

-shawn

[Ronny_Dsouza]

Hey Shawan,

would it be possible to share the job , it would be of great help

[skillman]

Ronny, I have attached the job in a Data Management package file as well as the ddf file.

Let me know if you have any questions importing it into your environment, or any questions about the job itself.

Thanks,

-shawn