NodeDB Partitioning

Manipulator

This node split rows from a DB Data table. The dialog enables you to specify the number of rows to split and the splitting strategy.

The created partitions might overlap depending on the database and the selected sampling option. KNIME is not storing the data of the first partition in any way but is executing the query that represents the first partition also as part of the query to retrieve the second partition. If the query that defines the first partition returns a different result for each execution the two partitions might overlap. This is most likely the case for random sampling without a fixed seed.

Input ports

  1. DB Data Type: DB Data
    DB Data to apply database sampling.

Output ports

  1. First DB Data partition (as defined in dialog) Type: DB Data
    First DB Data partition with sampled rows.
  2. Second DB Data partition (remaining rows) Type: DB Data
    Second DB Data partition with sampled rows.