Clone table and set row header

Question

question

Rahul R asked Apr 18, '23 Jason Lightfoot edited Apr 18, '23

Clone table and set row header

Hi,

I am looking to see if there is possibility to CLONE select columns to a new output table and have one of the columns as row header. I know i can clone the table first and iterate over the output table to set row header. Is there a better way to do this?

Table.query("SELECT .....").cloneTo("Output_table");

Software Version:

FlexSim 23.1.1

sql queries table.query rowheader clone

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2023-04-18T11:14:21Z

Jason Lightfoot answered Apr 18, '23 Jason Lightfoot edited Apr 18, '23

You might find some performance gain in one method versus another but if your dataset is large and you want to access it repeatedly, I would recommend you switch to a bundle and use an index rather than row headers - it's significantly faster to look up data in large datasets.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question