Extend one value for the rest of the column

[Juliane]

Hello Community, I have combined CSV and now I would like to add the value in the column “Value” to all URLs in the list. I can’t do it with the Constant Value, because the “Value” is different for each CSV combination (but the rest of the structure of the combined CSV remains the same). Does anyone have an idea how I can solve this? I have already tried different variants, but I can’t get a result.

[mlauber71]

@Juliane you can employ the Missing Value node

Copy values from previous row to next row until a row has data.

Hi @Dheeraj_7716 Welcome to the KNIME forum! A way to do this is with the Missing Value node. It allows the option to use the previous value for missing values. I used a simplified version of your example: [image] Within the Missing Value node, add Column1 and Column3 to the list under Column Settings and select Previous Value. [image] Final result: [image] Hope this helps!