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

[Anonymous]

Hi,

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi kumar22011993,

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

Best regards
Sabrina