How tAggregateRow works?

One Star

How tAggregateRow works?

Hi,
I hope you can help me.
I'm reading Component Guide of Talend and I just can't understand
how the tAggregateRow works ( Page 710 ).
Some questions:
1. How can I know what the functions do? (count, min,
max, avg, sum, first, last, list, list(objects),
count(distinct), standard deviation).
2. In the manual, in 'Input Column Position', he puts 'Points' without show what it means.
3. Finally, in the manual, he didn't show the types that should been chosen (String,int,float,...)
Thnks a lot, and I'm so sorry because my english is not good, I'm Brazilian.
Community Manager

Re: How tAggregateRow works?

Hello
1. How can I know what the functions do? (count, min,
max, avg, sum, first, last, list, list(objects),
count(distinct), standard deviation).

There are common aggregate logic function, for example, count get the number of rows group by the key columns. min get the minimum value of rows group by the key columns.
2. In the manual, in 'Input Column Position', he puts 'Points' without show what it means.

In the 'input column position' choose the columns from input schema as group keys.
3. Finally, in the manual, he didn't show the types that should been chosen (String,int,float,...)

The data type is defined on the schema.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How tAggregateRow works?

shong,
Thank for your answer, but I still can't understand some points.
Like I said, in the manual is not specified the type that I have to choose in the schema,
so I'm choosing and receiving this message:
"Warning: the operation 'count ' for the output column 'Name1' can't be processed
because of incompatible input and/or output types. "
I want to compare two columns of names, and to do that, I'm choosing that two like 'key'.
In the types I'm putting 'String' and I'm adding 3 columns: 'Average', 'Max' and 'Min', all
of them like double.
Thank you.
Employee

Re: How tAggregateRow works?

in your output schema you have a column named "Name1". In the operation menu of the tAggregateRow you shoudl have a line with a count operation (with Name1 defined as an output column, right ?).
So now if you take a look on your output schema Name1's type should be String which is wrong, since a count operation return a numeric value (change it to Integer). Same logic for others output columns that will contains results of Sum, Average...

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch