https://community.qlik.com/t5/Talend-Studio/Record-Count-at-ID-level/m-p/2214385#M11262 <P>Hi</P> <P>I'm trying to achieve an equivalent of a COUNT(*) GROUP BY 2 fields in SQL within a Talend flow but at the moment we are reading a table and writing out a sort/uniq'd output to a MySQL table, then having a second subjob that reads the output from the first step and counts the number of rows per ID.</P> <P>&nbsp;</P> <P>Any idea whether it would be possible to run this in a single subjob flow or whether we should keep these jobs separate and run the count in raw SQL?</P> <P>Thanks</P> <P>Dave</P> Wed, 23 Jan 2019 17:13:30 GMT Anonymous 2019-01-23T17:13:30Z https://community.qlik.com/t5/Talend-Studio/Record-Count-at-ID-level/m-p/2214385#M11262 <P>Hi</P> <P>I'm trying to achieve an equivalent of a COUNT(*) GROUP BY 2 fields in SQL within a Talend flow but at the moment we are reading a table and writing out a sort/uniq'd output to a MySQL table, then having a second subjob that reads the output from the first step and counts the number of rows per ID.</P> <P>&nbsp;</P> <P>Any idea whether it would be possible to run this in a single subjob flow or whether we should keep these jobs separate and run the count in raw SQL?</P> <P>Thanks</P> <P>Dave</P> Wed, 23 Jan 2019 17:13:30 GMT https://community.qlik.com/t5/Talend-Studio/Record-Count-at-ID-level/m-p/2214385#M11262 Anonymous 2019-01-23T17:13:30Z https://community.qlik.com/t5/Talend-Studio/Record-Count-at-ID-level/m-p/2214386#M11263 <P>Hi,</P><P>&nbsp;</P><P>Split out the data you want to get the GROUP BY on with a tReplicate (so it gets its own feed to perform the aggregation on) and then either tSortRow/tAggregateSortedRow or tAggregateRow, depending on data volumes.</P> Wed, 23 Jan 2019 17:28:48 GMT https://community.qlik.com/t5/Talend-Studio/Record-Count-at-ID-level/m-p/2214386#M11263 David_Beaty 2019-01-23T17:28:48Z