DSXchange

Hi all

I have need to populate top five decimal values after doing validations for which i have used transformer stage.

Pleae share how do handle this .

Thanks in advance

nani0907 wrote:...populate top five decimal values...

Could you explain what you mean by that? Is it the rows with the 5 largest values in one column, or 5 decimal columns and getting the highest among them or some other action?

It is to populate five largest decimal values.

I am afraid that I still don't quite understand, would it be possible to give a short simplified example of what you wish to do?

I getting the data as below

column A Column B
1 20.9
2 10.8
3 27.4
4 15.3
5 32.1
6 15.7

Output to be generted only for top five column B values in descending order
Coumn a Column B
5 32.1
3 27.4
1 20.9
6 15.7
4 15.3
Please help me out .

rank the columns and then based on column ranking filter only the first five records.

p.s i am sure your next question would be how to rank. for that search the forum :D

Sort the data by descending value, then limit the output to the first 5 rows.

How to limit the output to the first 5 rows

single-thread a transform stage (sequential as opposed to parallel, or a 1-node configuration) and then put a constraint "@INROWNUM < 6" in.

Thanks a lot

Iam able to get required output

Thanks a lot

Iam able to get required output