How to combine data of two or more Global Tables in one Global Table

Question

question

Luis Fernando asked Dec 14 2023 at 6:33 PM Luis Fernando commented Dec 14 2023 at 11:26 PM

How to combine data of two or more Global Tables in one Global Table

Hi FlexSim team,

How can I combine two or more tables in just one table?

I have done a small example of that question.

I want to place the output data of the table "Processor1" and "Processor2" in the table called "All lines".

1. How to combine two or more tables.fsm

Thanks,

Software Version:

FlexSim 23.2.2

tables combine tables

1702578625693.png (10.9 KiB)

1-how-to-combine-two-or-more-tables.fsm (38.1 KiB)

Answer 1 · 2023-12-14T18:36:10Z

Jason Lightfoot answered Dec 14 2023 at 6:36 PM Luis Fernando commented Dec 14 2023 at 11:26 PM

Use a query with the UNION ALL clause.

Table.query("SELECT * FROM Processor1 UNION ALL SELECT * FROM Processor2").cloneTo("All Lines")

· 4

Luis Fernando commented · Dec 14 2023 at 7:19 PM

Hi Jason,

Please, could you attach the model with this code suggested?

I am trying to paste the code, but appears an error in my model,

Thank you,

0 ·

Luis Fernando Luis Fernando commented · Dec 14 2023 at 7:21 PM

This is the result obtained after the code:

0 ·

1702581682542.png (12.0 KiB)

Jason Lightfoot ♦♦ Luis Fernando commented · Dec 14 2023 at 10:31 PM

You can either add the processor field to table with something like:

Table.query("SELECT 'Processor1',* FROM Processor1 UNION ALL SELECT 'Processor2', * FROM Processor2").cloneTo("All Lines")

or if you want it like your picture you can use:

treenode t=reftable("All Lines");
t.subnodes.clear();
Array tables=["Processor1","Processor2"];
while (tables.length){
    string tabname=tables.pop();
    treenode row=reftable(tabname).first;
    while (row) {
        row.copy(t);
        row=next(row);
    }
}

0 ·

Show more comments

question