Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Hi,

How to use GROUP BY value(column name) in talend?
Labels (2)
11 Replies
Anonymous
Not applicable
Author

Hi
You might use tSortRow to do group by.
Regards,
Pedro
Anonymous
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

can i write this query(entire query) in expression filter is it possiable?
Anonymous
Not applicable
Author

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. 0683p000009MACn.png
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
Not applicable
Author

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

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

Hi kumar22011993,

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

Best regards
Sabrina