Hello,
I am creating a custom code where I need to clone just an existing column into a new column, mantaining both for ordering. I cannot see any command that allow me to do this, not clone, clone to, addcol, etc.
Any thoughts?
Best regards,
Hi Marc,
You can use .addCol() and then a loop to clone values for all rows. You can also copy all values using a Table.query like this: Table.query("UPDATE GlobalTable1 SET [Col 4] = [Col 2]").
For example:
Table temp = Table("GlobalTable1");
temp.addCol();
temp.setColHeader(temp.numCols, "Col 4");
Table.query("UPDATE GlobalTable1 SET [Col 4] = [Col 2]");
15 People are following this question.
