topic Re: How to get fifth highest value from a column in Talend Studio

How to get fifth highest value from a column

Anonymous — Thu, 30 Nov 2017 11:10:39 GMT

A source table contains emp_name and salary columns.

I want to have a mapping to load all records with 5th highest salary into the target table.

Re: How to get fifth highest value from a column

Anonymous — Thu, 30 Nov 2017 11:26:39 GMT

The best option is making from the source, if your source is oracle you could make a query that returns you the 5 rows you need.

Also you could use a tSortRow component sorting column salary in desc order, then a tmap component where you declare a var with numeric sequence (using the internal talend function) from value1 and increment by 1, and an output with a condition where you evaluates this variable and if its value is between 1 and 5 then the output is valid.

Re: How to get fifth highest value from a column

Anonymous — Thu, 30 Nov 2017 11:53:33 GMT

Can u please attach some screenshots for clear understanding . Thanks in Advance

Re: How to get fifth highest value from a column

Anonymous — Thu, 30 Nov 2017 12:20:43 GMT

Here are the screenshots

General ViewMy source dataSource SchematSortRow configtMap config with sequenceFinal Results

Re: How to get fifth highest value from a column

Anonymous — Thu, 30 Nov 2017 12:23:18 GMT

Thank you very much

Re: How to get fifth highest value from a column

Anonymous — Sun, 28 Jun 2020 16:52:50 GMT

Using tMap component we can get the Top 5th highest record. If you follow below steps in tMap component we will get only top 5th highest record. In this example I am taking top 5th salary paid from the employees.

Step-01: Below is the Job Flow, Using tSortRow and tMap components.

Step-02: In the tSortRow component sort the data as mentioned below.

Step-03: In the tMap component, create the variables like

SeqID = Numeric.sequence("SID",1,1) and in the Expression filter give the condition as Var.SeqID == 5.

Steo-04: Now run the job and see the output in the tLogRow component. We will only one record, which is top 5th salary from employees.

Re: How to get fifth highest value from a column

Anonymous — Sun, 28 Jun 2020 16:52:50 GMT

Step-01: Below is the Job Flow, Using tSortRow and tMap components.

Step-02: In the tSortRow component sort the data as mentioned below.

Step-03: In the tMap component, create the variables like

SeqID = Numeric.sequence("SID",1,1) and in the Expression filter give the condition as Var.SeqID == 5.

Steo-04: Now run the job and see the output in the tLogRow component. We will only one record, which is top 5th salary from employees.

Re: How to get fifth highest value from a column

TRF — Sun, 28 Jun 2020 17:18:46 GMT

Much more easier, tFileInputDelimited-->tMap-->tSampleRow

Re: How to get fifth highest value from a column

TRF — Sun, 28 Jun 2020 17:18:46 GMT

Much more easier, tFileInputDelimited-->tMap-->tSampleRow