Icon

m_​001_​split_​data

Splitting given data into n equal parts using random numbers

I built this workflow that takes some data, uses random numbers to sort them and then split hem into a given number of parts and store them in KNIME tables. Still wondering if there is an easier way.

You could also combine an iteration of the Partitioning node.

https://forum.knime.com/t/splitting-data-into-parts/13056/4?u=mlauber71 Splitting given data into n equal parts using random numbers new_id=> originalsorting0 to v_no_partsroundto integerlist sort_id=> random sortingv_no_partsjoin part 0 and the highest numbercheck the distributionof the clusterscreate random numberssort by random numbercreate pathselect groupSTARTwrite tableENDData Generator Java Snippet(simple) Normalizer (PMML) Math Formula GroupBy Java Snippet(simple) Integer Input(legacy) Rule Engine Pivoting Quasirandom SequenceGenerator (Apache) Sorter Java EditVariable (simple) Rule-basedRow Filter Table Row ToVariable Loop Start Table Writer String to Path(Variable) Variable Loop End https://forum.knime.com/t/splitting-data-into-parts/13056/4?u=mlauber71 Splitting given data into n equal parts using random numbers new_id=> originalsorting0 to v_no_partsroundto integerlist sort_id=> random sortingv_no_partsjoin part 0 and the highest numbercheck the distributionof the clusterscreate random numberssort by random numbercreate pathselect groupSTARTwrite tableENDData Generator Java Snippet(simple) Normalizer (PMML) Math Formula GroupBy Java Snippet(simple) Integer Input(legacy) Rule Engine Pivoting Quasirandom SequenceGenerator (Apache) Sorter Java EditVariable (simple) Rule-basedRow Filter Table Row ToVariable Loop Start Table Writer String to Path(Variable) Variable Loop End

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: m_lauber
Created at: 2019-01-01
On NodePit since: 2019-12-14
Last update: 2024-04-23
Created with KNIME version: v4.7.8
Tags: splitdataequalpartsjava

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

Try NodePit Runner!