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

Question

question

Luis Fernando asked Dec 14, '23 Luis Fernando commented Dec 14, '23

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, '23 Luis Fernando commented Dec 14, '23

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 07: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 07: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