Icon

split-rows-by-number

This workflow is the response to a question by YouTube user Rashed Al Naamani: Hello Phil…could you please let me know how can I split a dataset to multiple tables…example …I have a dataset having 10,000 rows…and I wand every 1000 row to beallocated to a table ..at the end I will have 10 tables with 1000 rows each…thanks in advanceLink to the video: https://www.youtube.com/watch?v=fF4HqrERnXE&lc=Ugyg54LygVn3Ard1OiN4AaABAg read basetablesplitevery 1,000rowswrite table todata areacreate filenamecreate file pathNode 6needed toexecute loop end Table Reader Chunk Loop Start Table Writer String Manipulation(Variable) String to Path(Variable) Loop End Empty Table Creator This workflow is the response to a question by YouTube user Rashed Al Naamani: Hello Phil…could you please let me know how can I split a dataset to multiple tables…example …I have a dataset having 10,000 rows…and I wand every 1000 row to beallocated to a table ..at the end I will have 10 tables with 1000 rows each…thanks in advanceLink to the video: https://www.youtube.com/watch?v=fF4HqrERnXE&lc=Ugyg54LygVn3Ard1OiN4AaABAg read basetablesplitevery 1,000rowswrite table todata areacreate filenamecreate file pathNode 6needed toexecute loop end Table Reader Chunk Loop Start Table Writer String Manipulation(Variable) String to Path(Variable) Loop End Empty Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: philk
Created at: 2022-10-22
On NodePit since: 2022-10-23
Last update: 2024-05-03
Created with KNIME version: v4.6.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!