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.
Watch the recorded webinar!
Learn how to use an API-First Approach to Modernize your Applications
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