One Star

how to design aggregator transformation issue

hi all......
i designed mapping by using aggregator tranformation.......like this below

group by

outcolumn input column position
dealno dealno
but....
Question:-in my input table having some other columns(brncd,crline,fccd,prline...,dealno),
but i need group by(brncd,crline,fccd,prline...,dealno)all columns and out is onely one column: dealno
1.how can do changes in aggregator transformation?
and also could u tell me how can upload images?

BEST REGARDS
SHIVA
1 REPLY
Community Manager

Re: how to design aggregator transformation issue

Hello Shiva
1.how can do changes in aggregator transformation?

On tAggregateRow component, output all columns, then add a tFilterColumn component after tAggregateRow and output dealno column on tFilterColumn.
and also could u tell me how can upload images?

Using other tools(ps: I am using snagit) to capture images on local machine first, then upload them from local machine to Talend forum. (see my screenshot)
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business