One row to many rows numeric (disaggregating data)

Hi everyone,

I am trying to dissagregate this data to make it match our standard workflow for Sales Funnel, data is different because it is coming from a different BU.

 

Need to convert this:

date Leads NewSales
1/2/2017 2 1
1/3/2017 3 2

 
   


Into this

date Leads NewSales
1/2/2017 1 1
1/2/2017 1 0
1/3/2017 1 1
1/3/2017 1 1
1/3/2017 1 0
     

 

Have been trying for a with different methods without success.

 

Please don't post your questions twice. It will not help in getting a faster answer.

Thank you! Iris

PS: Original is here: http://tech.knime.org/forum/knime-general/trouble-dis-aggregating-data-on-knime-one-numeric-row-to-many 

sure, I posted it again because the first one showed as archived for a few days.. Thought it was marked as spam

sure, I posted it again because the first one showed as archived for a few days.. Thought it was marked as spam

 

Cheers