copying cell entries a set number of times into cells below

KNIME Analytics Platform
#1

Hello,

 

I would like to copy cell entries and paste them into empty cells a set number of times.

Here is an example:

I want to fill 2 cells (indicated by the 'number' column) with "Hello" from the 'text' column and 4 cells with the text "Bye" into the cells beneath.

RowID number text
1 2 Hello
2    
3    
4    
5 4 Bye
6    
7    
8    
9    

That's what it's supposed to look like:

RowID number text
1 2 Hello
2   Hello
3   Hello
4    
5 4 Bye
6   Bye
7   Bye
8   Bye
9   Bye

 

I have absolutely no clue how to do this. Maybe someone knows a node or a combination of nodes that'll do it?

Help is much appreciated!

 

1 Like
#2

Hi Michael,

you can only fully achieve this with a Java Snippet or with a loop maybe.

 

Is there a reason Row Nr. 4 does not need the Hello Text?

We would e.g. have the Missing Value node, it has an option Last. And with this you can replace a missing value in a column with the last value in this column.

Best, Iris 

#3

Hi Iris,

yes the cell in row 4 is supposed to stay empty.
But I believe the Missing Value Node could already help me a lot nonetheless. I’ll try to work around this somehow.

Thank you very much!