i have a CSV file with 20 rows and i need output by skipping every 5th row and skipped rows i need to move to excel file.
Can you please help me on this?
Use a sequence in a tMap with 2 output flows and filter a specific filter for each.
Filters can be based on the result of a division by 5. If rest is 0 or not to decide which flow to go.
It should be something like this....
If the sequence number is divisible by 5 (% is a modulus operator), then the code above will return "true". In which case you can filter the row in your output table.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs