Here my question :
Generate 1000 records (1.... 1000) as input.
Expected output: - 1, 100, 200,300,400,500,600,700,800,900,1000 these 11 records alone.
Please help me to find this.
Solved! Go to Solution.
A job like this one may answer your question. (see attached document)
In this job, I have a ".csv" file in input. This "csv" contains only one column with records from 1 to 1000.
In the "Var expression", I filter on the values I want in output.
My output is a ".csv" file too.
I hope this job will help you.
Thankyou for your reply tdz,
but, If you have more fields how can we extract? Here 1000 rows so we can use this but one million records then we can't able to give every particular row right?
So how to get all first row and all multiples of 100 .
Please let me know if you are not able to get this.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables