topic Re: Aggregate rows, include all detail in output in Talend Studio

Aggregate rows, include all detail in output

Anonymous — Sat, 16 Nov 2024 12:59:22 GMT

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.

Re: Aggregate rows, include all detail in output

Anonymous — Mon, 11 Apr 2011 22:58:46 GMT

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

Re: Aggregate rows, include all detail in output

Anonymous — Mon, 11 Apr 2011 23:10:20 GMT

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?