Create N rows on the basis of column value

i attached 2 screenshots :

  1. which is in the existing table into database.
  2. I want data into the format which is 2nd screenshot . where data is repeat on basis of value num =3 and fee is divide by value and in date 1month is added every time .
1 Like

Hello @Kanika_1234 and welcome to the KNIME community

Have you tested ‘One Row to Many’ node?



it’s not working I used it after fetching the data .

I see,
You can use Create Date&Time Range node starting from available ‘date’ (‘value’ == number of periods). And then apply a joiner or xjoiner depending the use case.

See attached workflow:

20230509_create_rows_from_time_periods.knwf (24.8 KB)



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