clone column in a table

Question

question

Marc R5 asked Apr 13, '22 Iago MF answered Apr 13, '22

clone column in a table

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,

Software Version:

FlexSim 22.0.2

custom code column clone

Answer 1 · 2022-04-13T07:43:34Z

Iago MF answered Apr 13, '22 Marc R5 commented Apr 13, '22

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]");

question