tELTMySQLMap - group by for creating aggregate table?

[Anonymous]

Hi there,
I have a job that creates an aggregate table using tMap. It works fine (first screen shot). I thought I'd try out ELTMap.
I got the aggregates by entering expressions in the ELTMap, e.g.: sum(sales_fact_1998.store_sales). I can't figure out how to implement the Group By and Order by clauses (second screen shot).
Can anyone point me in the right direction? I tried the documentation and searched the forums (and Google).
Many thanks,
Mary

[Anonymous]

hi, i would also like to know how to use the group by functionality. thanks.

[Márcio_Lopes]

Hello,
This topic is old, but I will let the answer for the people like me who came here looking for the answer and don?t have it .

You can do the group by clauses and where clauses by Click on the Add filter row button at the top of the output table (see image):
Like you can see it appears a place for Additional clauses.
I hope this can help someone.

[_AnonymousUser]

Hi,
1. Click a Filtering button(Right arrow and green plus mark) at Output table in editor.
You can choose and .
2. Use .
Additional other clauses editor come up.
3.write like this.
GROUP by Data.ID
you can use .

[Anonymous]

Hi,
I have a table like this -
Attached Snapshot -
-
Suppose there are thousands of rows and I have to find all those city where there is no manager. how can I do this through Talend?