mysqlcsvpentahopentaho-spoonpentaho-data-integration
How to start inserting row after some specified number to MySql database using Pentaho?
Basically what i want to do is that,
I have CSV file containing 10,000 rows that i want to insert into the database . When i start my transformation i want to start inserting in database after 4500 rows . So i want to skill number of rows that i specified .
How can i achieve that ? Any help would be great.
Image Description : I simply create a transformation that read data from csv and write to database . I do not know which step will help me to achieve this .
Note : I have attached my simple transformation 
Solution
I used following kettle file , that solved my problem .
Thanks to @WorkingHard..and @jxc 
- I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
- find number of rows in returned mysql result (nodejs)
- Get records that have total count of over X amount
- Excluding records between dates AND with an associating value
- MYSQL Update query, replace part string containing URL
- MySQL Not Equal To Certain Length
- How can I solve "Error: MySQL shutdown unexpectedly"?
- How do I turn off the mysql password validation?
- How to create table like another table with additional columns in MYSQL
- How import also column name in CSV file
- Export Column Names to CSV
- split characters and numbers in MySQL
- If only CI fails, what kind of trouble could there be for django?
- Perform an INNER JOIN with more than 2 tables in MySQL
- Imploding a list for use in a Python MySQL IN clause
- SQL check if timestamp is greater than 24 hours from now (MYSQL)
- SQL - Query to find if a string contains part of the value in Column
- MySQL stored function: CONTAINS SQL or NO SQL?
- MySQL "delayed commit ok done" and performance
- MySQL Query performance - best partial match
- MySQL: How to reset or change the MySQL root password?
- How to reset the root password in MySQL 8.0.11?
- Count 'IN' value in MySQL from multiple non-normalized columns
- coupon code statistics
- How to return NULL when result is empty?
- Extract dirname from full path stored in database
- Using larger than or equal (>=) to in PreparedStatement in Java
- What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?
- Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax
- How to find the minimum of a sum of values based on a distinct value?