How to use GROUP BY value(column name) in talend?

One Star

How to use GROUP BY value(column name) in talend?

Hi,

How to use GROUP BY value(column name) in talend?
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi
You might use tSortRow to do group by.
Regards,
Pedro
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi Pedro ,
This is example how to apply this conditions in talend i need ur help.
SELECT SUBSTRING((SELECT data1.value FROM data1 WHERE data1 .entity_id =data.entity_id AND (data1 .no= 10) GROUP BY VALUE ),1,20) AS NAME FROM data
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi
As we said before, you can finish the following query by using tMap.
SELECT data1.value FROM data1 WHERE data1 .entity_id =data.entity_id AND (data1 .no= 10)
Then link tMap with tSortRow to do group by value.
Now what we need to do is SUBSTRING.
Link tSortRow with another tMap. Type the expression in the OUT1 like this row3.value.substring(1,20).
Regards,
Pedro
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi Pedro,
from last week i started this query but i didn't get output , everyday i tried different ways but i didn't get output
plz give me screen shot about this query
One Star

Re: How to use GROUP BY value(column name) in talend?

can i write this query(entire query) in expression filter is it possiable?
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi
That's because in the beginning you gave me the query like this.
SELECT data1.value FROM data1 WHERE data1 .entity_id =data.entity_id AND (data1 .no= 10) LIMIT 1 ),1,20)
I just didn't understand why there is LIMIT 1), 1, 20). Then asked you whether this query was correct. You said yes. But in fact, you needed to type SUBSTRING in the beginning of this query.
Then instead, you showed me the entire query with more than 100 words. I got crazy. Smiley Happy
Now here are some images about your requirement.
Another workaround is you might run this entire query in tMysqlRow. I'm not sure because I don't have database data and can't test this entire query.
Regards,
Pedro
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi
I have received your email. You'd better exchange the location of these two tMsyqlInput.
Regards,
Pedro
One Star

Re: How to use GROUP BY value(column name) in talend?

Hi!
How to use Having count(column_name) in talend? Anyone Help me..
Moderator

Re: How to use GROUP BY value(column name) in talend?

Hi kumar22011993,

Could you please elaborate your case with an example with input and expected output values?
 

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to use GROUP BY value(column name) in talend?

how to group the column in talend
Five Stars

Re: How to use GROUP BY value(column name) in talend?

Hello,
myInout is MysqlTable 
select count(*), f_input,f_output from tab_fmail group by f_output , f_input,time

myOutput is also MysqlTable 
any suggestions please ?