How to Split every 1000 records in SQLite DB?

KNIME Analytics Platform
#1

Hi

How to Split every 1000 records from table in SQLite DB?

Extract table with records from SQLite DB and want to split number of records 

example below:

from 1 to 999 and

1000 to 1999 and

2000 to 2999 and

3000 to 3999 etc

 

#2

Hey,

Do you want to have all these selections in seperate KNIME tables? What are you going to do next with them? This information is crucial for me to suggest an efficient solution.

If the problem is the SQL, give this query a try (https://sqlite.org/lang_select.html):

SELECT * FROM table ORDER BY tablekey LIMIT x OFFSET y

Cheers,
Marten