Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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