Aggregate rows, include all detail in output

One Star

Aggregate rows, include all detail in output

Hi all,
TOS 4.1.2 - Windows XP - Java
Is there a way to aggregate values in a column whilst keeping all of the detail in the output? A simple example:
Product_ID||Price
1||5.99
2||12.99
3||8.99
Product_ID||Price||Max_Price
1||5.99||12.99
2||12.99||12.99
3||8.99||12.99
I need to work with the maximum value of a column in the input within the rows of the output. I assumed that if I used tAggregateRows and left all of the columns from the input in the output that it would do this but it outputs a single, mostly blank, row.
Thanks, Chris
NB I'm not a Java programmer but can hack about a bit if required.
One Star

Re: Aggregate rows, include all detail in output

Hi,
This will work but not particularly pretty :-
1) input schema = product_id and price
2) taggreagate - just get max price
3) Use aggregate as lookup into tmap - no join to lookup therefore the value goes out wil every row. If you have a group requirment you would aggreate based on group then join on group in tmap.
HTH
One Star

Re: Aggregate rows, include all detail in output

Is it possible to load all the (PRODUCT_ID, PRICE)'s then set MAX_PRICE for all records at the same time with an update statement?