The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

One Row to Many

Each row is multiplied depending on the number in the integer column. (E.g. you can use this node to create the items in a shopping basket, if you only have the number of items per baskets and then continue with the multiplied rows.)

Dialog Options

Amounts
The integer column containing the number the given row should be printed. If the number is smaller than one, the row is not displayed afterwards. (E.g. the number of items in one shopping basket.)
Prefix
The prefix for the new RowKey. The new RowKey is subsequently oldrowkey + prefix + counter, where the counter is a number from 1 to the number of new rows.

Ports

Input Ports
0 data containing one int. column
Output Ports
0 same data but with multiplied rows
This node is contained in KNIME Datageneration provided by KNIME GmbH, Konstanz, Germany.