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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.