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.
I added a workflow that hopefully does what you want. Not sure what you will do with it though You can set the no of ‘duplicates’ you want to have.
kn_example_duplicate_row.knwf (63.3 KB)
2 Likes
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…
CrossJoinBruteForce.knwf (9.8 KB)
3 Likes
thank you, this is what I wanted to do!
system
Closed
July 13, 2018, 6:13pm
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.