How to drag out one row to complete all the rows the same value (like in Excel)?

How to drag out one row to complete all the rows the same value (like in Excel)?

Hi @pjacob -

I don’t know that there’s a way to precisely reproduce that functionality in KNIME, but you might be able to approximate it with a Constant Value Column node and a flow variable.

1 Like

@ScottF It’s working but I want to execute this in loop and that’s my main problem.

Can you maybe post an example workflow, along with an example of what your input and desired output would look like?

@ScottF just replace “?” date at the bottom

Ah, in that case, maybe the Missing Value node with the Most Frequent Value option would work? Assuming you have only a single valid value in each field, that is.

3 Likes

@ScottF this is solution, thank you very much :smiley:

2 Likes

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