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.
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