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

One Star

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

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?

Accepted Solutions
Four Stars

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

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

View solution in original post


All Replies
Four Stars

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

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

View solution in original post

One Star

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

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

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

Hi,

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog