One Star

tELTMySQLMap - group by for creating aggregate table?

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
4 REPLIES
One Star

Re: tELTMySQLMap - group by for creating aggregate table?

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

Re: tELTMySQLMap - group by for creating aggregate table?

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 Smiley Happy.

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.
One Star

Re: tELTMySQLMap - group by for creating aggregate table?

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 .
One Star

Re: tELTMySQLMap - group by for creating aggregate table?

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?