batman
batman

Reputation: 1447

Talend: Aggregation summary?

I've seen how to use tMap in TOS to map different fields in a SQL-like JOIN. How do I aggregate based on certain 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 aggregate the results to that instead of the many entries of the non-unique B I can see something like:

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

Thanks!

Upvotes: 3

Views: 4168

Answers (1)

drmirror
drmirror

Reputation: 3760

You certainly can. Use the tAggregate component to do that. You can group by column B and then compute all of the different aggregations, like count, sum, and average in the other columns.

Upvotes: 5

Related Questions