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
