topic Re: How to output data in string format in FlexSim Forum

How to output data in string format

lancewu — Wed, 08 Nov 2023 01:51:06 GMT

[ FlexSim 22.0.16 ]

hi guys！

I want to output the content of this data in string format using code.As shown in the following image. What do I need to do?

Thank you for your review

Re: How to output data in string format

supportPHJ4A — Wed, 08 Nov 2023 03:08:07 GMT

treenode data = Model.find("Tools/StatisticsCollectors/StatisticsCollector1>stats/data");

string directory = modeldir();

if (!directory.length)

directory = documentsdir();

string fileName = getfilebrowse("*.csv", "Comma Separated Format", "", directory, 1);

exporttable(data, fileName, 1, 0);

Re: How to output data in string format

lancewu — Wed, 08 Nov 2023 03:14:38 GMT

Hi,thank u.

but I don't want to save this data as a file locally, I just want to convert it into string text

Re: How to output data in string format

jason_lightfoot_adsk — Wed, 08 Nov 2023 12:41:17 GMT

'Output' is meaningless unless you qualify the destination - most would assume a text file.

Re: How to output data in string format

jason_lightfoot_adsk — Wed, 08 Nov 2023 12:56:03 GMT

Try something like this:

Table.query("SELECT StatisticsCollector.getPathFromID(Object),State,Time, Utilization FROM [State Collector]").cloneTo(Table("temp"))

Re: How to output data in string format

xucq — Thu, 09 Nov 2023 01:50:19 GMT

You can define this node with the type of the table, and then read every row and column in the table in the same way that the table reads, and write it into a text.

To define the table, see Jason's response above, or see the following:

Table data = Model.find("Tools/StatisticsCollectors/StatisticsCollector1>stats/data");