How to copy a column?

M42 · April 16, 2018, 8:46am

How can I copy a column? I want to append the same column with a different name to the table. I do not just want to rename the old column.

moritz.heine · April 16, 2018, 9:16am

Hi,

simply use the Column Filter Node to filter the column you want to copy and then use the Column Appender Node to append the filtered column to your original table.

Cheers,
Moritz

M42 · April 16, 2018, 9:19am

That is what I have been doing so far - plus using the Column Rename node of course. Using three nodes seemed pretty complicated to me for copying a column. But it seems there really isn’t a single node for this (simple) task :-/. Oh, well.

ipazin · April 16, 2018, 9:23am

Hi there!

You can use Rule Engine node for this with Expression
TRUE => $Your_Column$
with option Append Column.

Hope this helps

BR,
Ivan

system · April 23, 2018, 9:23am

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