topic Re: How to dynamically copy list entries to a table in FlexSim Forum

How to dynamically copy list entries to a table

patrickABAWF — Tue, 28 Aug 2018 16:12:55 GMT

[ FlexSim 18.1.2 ]

I'm looking to copy the entries on a list to a table every X seconds so that I can later make stats on those entries.

I know how to create a loop in a process flow that reads a custom code every X seconds and I know how to write to a table.

What I'm missing is the command to read the list content.

Thanks,

Re: How to dynamically copy list entries to a table

arunTTT2P — Tue, 28 Aug 2018 16:39:30 GMT

Hi Patrick Cloutier,

You can write an SQL query to pull/copy the data from the list and dump the queried data into the global table.

Table Result = Table.query("SELECT * FROM ListName");
result.cloneTo(Table("QueryDump"));

Regards,

Arun KR

Re: How to dynamically copy list entries to a table

patrickABAWF — Tue, 28 Aug 2018 17:17:54 GMT

Will this overwrite the data every time I copy or will it append to the table? I need that second option.

Re: How to dynamically copy list entries to a table

patrickABAWF — Tue, 28 Aug 2018 19:21:46 GMT

My list is called People and my table is called CountCor2 so I wrote:

Table result = Table.query("SELECT * FROM People");

result.cloneTo(Table("CountCor2"));

And I get the error message:

Property "dataType" accessed on invalid node and it erases the content of the table.

What am I doing wrong ?

Re: How to dynamically copy list entries to a table

patrickABAWF — Tue, 28 Aug 2018 20:36:05 GMT

That error was when my code was in a userevent. I put the code in the process flow instead and it works.

But as indicated earlier, I need to append to the table and not overwrite it. How can I do that?

Re: How to dynamically copy list entries to a table

joerg_vogel_HsH — Wed, 29 Aug 2018 01:15:04 GMT

You clone the tables to arrays. Then you append one to the other. And finally you make a table query over the array to get a table again.

Re: How to dynamically copy list entries to a table

arunTTT2P — Wed, 29 Aug 2018 07:55:33 GMT

Hi Patrick Cloutier,

I was thinking how the appending and overwriting makes a difference. Can you explain more on your requirement?

Re: How to dynamically copy list entries to a table

patrickABAWF — Wed, 29 Aug 2018 12:56:48 GMT

Every X seconds I want the content of the list to be copied to a table without erasing what was copied X seconds earlier. The table keeps getting longer and longer.

Re: How to dynamically copy list entries to a table

patrickABAWF — Wed, 29 Aug 2018 13:48:38 GMT

OK I made it work. I cloneto the list to a table and then I append this table to another table using a for loop that I created.

It works EXCEPT that some of the columns in my table are in pointer format so I need to convert them to string format. I tried tostring() but it doesn't work.

Here is the statement that works:

Table("CountCor2Append")[lastrow+i][1] = Table("CountCor2")[1];

How do I convert to string at the same time?

Re: How to dynamically copy list entries to a table

philboboADSK — Wed, 29 Aug 2018 18:34:42 GMT

Cast the value to a treenode and call getPath():

Table("GlobalTable1")[1][1].as(treenode).getPath()

Also, you don't need to use the intermediate table. Just use a for() loop to iterate through the returned query result Table rather than cloning it and then using a for() loop through the clone.