Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The most simple way is to add a numeric sequence to your inbound record. Then add an output expression where the reminder of sequence number division by 10 should be zero. In this way, you can pick the records which are 10,20,30, etc.
If you can use a context variable instead of 10, then you can change this from 10 to evry 5 records or every 7 records and so on.
To put an upper cutoff limit, you need to add another output filter condition where the sequence number generated should be less than the upper cutoff number (again a context variable which can be set at beginning of job).
Hope it has helped you
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
You might find this easier using a tMap and a modulus operator. For example, look at the tMap I have quickly knocked up below....
You will have to excuse the column names. In this example newColumn is your ID column. What I have done is used a filter in the outbound table. What the filter does is only pass the data out for records where the field holding the ID (newColumn) is divisible by 10. The code I have used is below....
row8.newColumn % 10 ==0
This says where the value is divisible by 10 with a remainder equalling 0.
Give that a try. You do not need to know the total number of rows for this.
