Geek asks and answers

Talend: Aggregation Summary?

I saw how to use tMap in TOS to map different fields in an SQL-like JOIN. How can I aggregate based on specific fields?

If I have two tables:

[ A, B, C, D ]
and               that are tMap'ped to  [ B, C, F, G ]
[ B, E, F, G]

how can I combine the results with this, and not with a lot of non-unique B entries, I can see something like:

[ B, count(B), avg(C), avg(F), avg(G) ]

Thank!

+3
source share
1 answer

You certainly can. Use the tAggregate component to do this. You can group by column B and then calculate all the different aggregations, such as count, sum and average in other columns.

+5
source

More articles:


All Articles