topic Re: [resolved] tAggregateRow: how to pass columns which does not need processing. in Talend Studio

[resolved] tAggregateRow: how to pass columns which does not need processing.

Anonymous — Wed, 04 Jun 2014 10:15:42 GMT

Hey,
I am using tAggregateRow to take sum of a column value using group by feature of this component. it works fine.
I have multiple columns in the input table. I am applying sum to two columns.
The problem is that I get only this two columns in my output table and rest column values as null.
How to get data in all the columns from input table?

Re: [resolved] tAggregateRow: how to pass columns which does not need processing.

Anonymous — Wed, 04 Jun 2014 10:35:21 GMT

I think there is bit trouble in expectations...
If you aggregate data on two columns, how can other columns can contain values...
Try executing same query using query browser, you will understand..
Can you put your sample input records?
Vaibhav

Re: [resolved] tAggregateRow: how to pass columns which does not need processing.

Anonymous — Wed, 04 Jun 2014 11:06:31 GMT

Hey Vaibhav,
I understood what i was doing wrong. Thanks for understanding the issue.

Re: [resolved] tAggregateRow: how to pass columns which does not need processing.

Anonymous — Mon, 28 Jan 2019 12:25:53 GMT

Hi,

I am having same issue. I need to pass other columns without processing from tAggregate. how did you do this?

Re: [resolved] tAggregateRow: how to pass columns which does not need processing.

simonius — Mon, 22 Jun 2020 09:16:16 GMT

How do you this?