narasimha.inf

 Profile Answers by narasimha.inf 

• Jun 23rd, 2008

 

max(sal)

adilshariff

 Profile Answers by adilshariff 

• Jul 1st, 2008

 

Use max(Value) in expression transformastion

jryan999

 Profile Answers by jryan999 Questions by jryan999

• Sep 1st, 2008

 

You need to feed your ports through an Aggregator Tranformation.  eg.

Input  = salary.  Not output
Output = maximum_salary --> max(salary) - Output

Connect the maximum_salary fields to the output to use it
Define other keys as "Group by" as needed.

You cannot use max(salary) function in expression - it only works on a single row

dihydrox

 Profile Answers by dihydrox 

• Dec 5th, 2008

 

If you just need to get the max value by the end of session (to increment a value or put at the bottom of a flat file ) you can do the following. 

Let's say you need to find the max value for a port called INCOME.
You feed rows through an expression. You create a new port that is either going to be local variable or output (depending what you want to do with it). Call it  CURR_MAX and place it after the INCOME port. It will have the expression

IIF(CURR_VALUE>INCOME,CURR_VALUE,INCOME). That should do it.

Otherwise, you either need to use a sorter which does caching anyway, an Aggregator
or do a lookup on the source you are reading from where the lookup override SQL calculates the max(for relational) or it you are reading from a relational DB like Oracle, use an analytic function