Add rows


#1

Hi

I want to add more rows for example.

input:

|id|date |name|
|1 |01/01/2018|mario|
|2 |02/01/2018|paul|
|3 |03/01/2018|josh|

output

|id|date |name|
|1|01/01/2018|mario|
|1|02/01/2018|mario|
|1|03/01/2018|mario|
|2|02/01/2018|paul|
|2|03/01/2018|paul|
|2|04/01/2018|paul|
|3|03/01/2018|josh|
|3|04/01/2018|josh|
|3|05/01/2018|josh|

in a nutshell i need duplicate rows with diferents dates. thanks.


#2

I added a workflow that hopefully does what you want. Not sure what you will do with it though :slight_smile: You can set the no of ‘duplicates’ you want to have.

kn_example_duplicate_row.knwf (63.3 KB)


#3

You could use a brute force cross join, but it doesn’t give you much finesse in the ability to match dates with names. Also, it’s wildly inefficient at large scale. But, in the interest of giving you different options… :slight_smile:

2018-07-05%2014_53_45-KNIME%20Analytics%20Platform2018-07-05%2014_53_54-Joined%20Table%20-%202_2%20-%20Cross%20Joiner%20(Node%202)

CrossJoinBruteForce.knwf (9.8 KB)


#4

thank you, this is what I wanted to do!


#5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.