topic Re: First Five & Last Five Records in Talend Studio

First Five & Last Five Records

Mike_9 — Fri, 21 Aug 2020 07:57:09 GMT

In a table 100 records I want output like 1st five records and last five record total 10 records should be my output in talend.

Please help me for this solution.

Thank You !!

Anonymous — Fri, 21 Aug 2020 08:13:11 GMT

Is there a field that can be used to sort the records?

manodwhb — Fri, 21 Aug 2020 09:06:16 GMT

@Mukesh Padavala , if you have a field that can be sort first sort and then use tSampleRow component to get the records.

check the below link to know more about tSampleRow.

Thanks,

Manohar

Mike_9 — Fri, 21 Aug 2020 09:24:20 GMT

@Shicong Hong Yeah.. Index field were there !!