Appending columns of different lengths

Hello. I am using KNIME Analytics Platform 4.0.2, and I need to add a column having one row to a table having n rows. The ‘Column Appender’ node does so by filling the shorter row with missing values. However, I need the value to be duplicated instead - i.e., to get n same values in the appended column for the resulting table.

I figured I could do that by converting the one-row column to a variable, and then adding it to the table with the ‘Constant Value Column’ node. But I was wondering if there was a more elegant way around it.

I think you might be looking for the Cross Joiner node.

3 Likes

And right you are - it really did what I needed. Thank you.

1 Like

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