topic Re: tELTMySQLMap - group by for creating aggregate table? in Talend Studio

tELTMySQLMap - group by for creating aggregate table?

Anonymous — Sat, 16 Nov 2024 14:16:51 GMT

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

Re: tELTMySQLMap - group by for creating aggregate table?

Anonymous — Wed, 03 Mar 2010 17:55:17 GMT

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

Re: tELTMySQLMap - group by for creating aggregate table?

Márcio_Lopes — Wed, 07 Jul 2010 12:31:39 GMT

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.

Re: tELTMySQLMap - group by for creating aggregate table?

_AnonymousUser — Mon, 16 May 2016 07:43:34 GMT

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 .

Re: tELTMySQLMap - group by for creating aggregate table?

Anonymous — Wed, 27 Jul 2016 19:36:20 GMT

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?