Ranking

[Anonymous]

Hi,
Is it possible to gerneate ranks for both whole tables or intra-group ranks?
Thanks,
Jay

[Anonymous]

Yes I would definately be interested in that.

My input file contains:

Toronto;500000
Vancouver;200000
Paris;900000
Lyon;500000

My output is:

Starting job topic882 at 18:20 25/06/2007.
.---------------------------.
|         tLogRow_1         |
+-----------+--------+------+
| city      | sales  | rank |
+-----------+--------+------+
| Toronto   | 500000 |    2 |
| Vancouver | 200000 |    3 |
| Paris     | 900000 |    1 |
| Lyon      | 500000 |    2 |
'-----------+--------+------'
Job topic882 ended at 18:20 25/06/2007. 

[Anonymous]

Hi plegall,
I'm having trouble viewing your images. They are super small and don't seem to download.
Thanks for your help.
I am interested in ranks in general but more so in "group" ranks. This is all for use in jobs such as: https://community.talend.com/t5/Design-and-Development/One-output-as-multiuple-inputs/td-p/60889 or ones where it is desired to have a variety of calculations run up front and stored for later use in reports and other queries.
Best Regards,
Jay

[cbachu]

Hi all,please any body help me how to generate ranking positions for the column(Ex ALARY) using talend.