https://community.qlik.com/t5/Talend-Studio/Dense-Rank-function-in-talend/m-p/2325418#M95019 <P><SPAN>BI want to know how to use dense rank in this condition.if highest Marks having 3rows and lowest marks also 3 rows then how to find out that one.</SPAN></P> Wed, 21 Mar 2018 09:32:32 GMT Anonymous 2018-03-21T09:32:32Z https://community.qlik.com/t5/Talend-Studio/Dense-Rank-function-in-talend/m-p/2325418#M95019 <P><SPAN>BI want to know how to use dense rank in this condition.if highest Marks having 3rows and lowest marks also 3 rows then how to find out that one.</SPAN></P> Wed, 21 Mar 2018 09:32:32 GMT https://community.qlik.com/t5/Talend-Studio/Dense-Rank-function-in-talend/m-p/2325418#M95019 Anonymous 2018-03-21T09:32:32Z https://community.qlik.com/t5/Talend-Studio/Dense-Rank-function-in-talend/m-p/2325419#M95020 <P>I may have missed a setting in a component (if I have, I'd be interested to know about this) but I do not believe this functionality has been implemented. But it is very easy to implement if you use a tSortRow and a tMap. The tSortRow is self explanatory, but the tMap is a little more complicated to understand. In a tMap you can create tMap variables whic are processed from the top to the bottom in a strict order, they also keep their values between rows. Using this, we can keep track of when values change and implement a simple addition to a ranking number when the values change from the last row. This allows us to implement a dense rank. I have knocked up a brief example in Talend 6.2.1.</P> <P>&nbsp;</P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009LsKi">DenseRankExample.zip</A> Wed, 21 Mar 2018 10:09:47 GMT https://community.qlik.com/t5/Talend-Studio/Dense-Rank-function-in-talend/m-p/2325419#M95020 Anonymous 2018-03-21T10:09:47Z