How to dynamically copy list entries to a table

Question

question

Patrick Cloutier asked Aug 28 2018 at 4:12 PM Phil BoBo edited Aug 29 2018 at 6:36 PM

How to dynamically copy list entries to a table

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,

Software Version:

FlexSim 18.1.2

process flow list

Answer 1 · 2018-08-28T16:39:30Z

Arun Kr answered Aug 28 2018 at 4:39 PM Phil BoBo edited Aug 29 2018 at 6:36 PM

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

· 8

Patrick Cloutier commented · Aug 28 2018 at 5:17 PM

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

0 ·

Patrick Cloutier commented · Aug 28 2018 at 7:21 PM

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 ?

0 ·

Patrick Cloutier commented · Aug 28 2018 at 8:36 PM

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?

0 ·

Arun Kr Patrick Cloutier commented · Aug 29 2018 at 7:55 AM

Hi Patrick Cloutier,

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

0 ·

Patrick Cloutier Arun Kr commented · Aug 29 2018 at 12:56 PM

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.

0 ·

Joerg Vogel commented · Aug 29 2018 at 1:15 AM

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.

0 ·

Patrick Cloutier Joerg Vogel commented · Aug 29 2018 at 1:48 PM

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

How do I convert to string at the same time?

0 ·

Phil BoBo ♦♦ Patrick Cloutier commented · Aug 29 2018 at 6:34 PM

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.

4 ·

question