DSXchange

Hi All,

I am new to datastage and I am working on the following requirement.
I have source data and I have to sort this data in a descending order and provide the ranks for only top 5 . But the data can contain zeroes also. If the colB =0 then use another column to get the rank.

Please help me in doing this . I appreciate it.

Thanks
--DSDEV

Welcome aboard.

To my way of thinking, RANK is a display function, not something that an ETL tool should be asked to do.

It is possible, which a Search of DSXchange will reveal.

Begin by formulating your complete logic in English - this should readily translate into operations in the ETL job itself.