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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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