how to access and manipulating arrival table with process flow?

Question

question

Yash Patel asked Nov 07 2024 at 11:21 PM Felix Möhlmann commented Nov 12 2024 at 7:12 AM

how to access and manipulating arrival table with process flow?

Is it possible for me to look up the value in the arrival table which have not yet triggered and swap them with the current trigger based on model condition. for example below is the original arrival table.

Time Name Quantity Label

1 Part 1 X

2 Part 1 Y

3 Part 1 Y

4 Part 1 Z

5 Part 1 X

6 Part 1 Y

7 Part 1 Z

lets say now at time 4 when part Z is supposed to be created, target batch size is 3 I want part Y which was to be generated at time 6 to be generated now and same will be swapped with part Z which will now be generated at time 6. and this swap should only happen if there is availably to of part in future like

Time Name Quantity Label

1 Part 1 X

2 Part 1 Y

3 Part 1 Y

4 Part 1 Y

5 Part 1 X

6 Part 1 Z

7 Part 1 Z

which function can I use to access the arrival table and change / swap

Software Version:

FlexSim 24.2.2

processs flow arrival table

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2024-11-11T08:25:04Z

Felix Möhlmann answered Nov 11 2024 at 8:25 AM Felix Möhlmann commented Nov 12 2024 at 7:12 AM

The schedule table is stored in the activity's attribute tree. Once you cast it as a table you can read and write to it just like a global table.

Table schedule = Model.find("Tools/ProcessFlow/ProcessFlow/Source>variables/arrivals");
schedule[2][4] = 8;

Though I would suggest to simply not have predetermined labels in the source at all. Keep a list of yet to be produced parts somewhere (for example in a global variable array). Then, whenever a token is generated it dynamically checks which part is "best" to be produced now. That way you don't need to worry about finding the next schedule row that has not triggered, swapping entries to a different row and resetting the table to its original state on model reset.

· 2

Yash Patel commented · Nov 11 2024 at 6:01 PM

I'd assume for looking up ill just have to iterate over whole table in a for loop? and since I want to match multiple columns in actual use case I'd have to iterate over all rows and columns? also could you guide me to documentation about global variable array please.

0 ·

Felix Möhlmann Yash Patel commented · Nov 12 2024 at 7:12 AM

Yes, using for-loops to iterate through the table is one option. You could also use the getRowByKey method to find the first row with a matching cell value.

Or you use a query which would allow you to filter/sort by multiple columns. For example, the following code would return the row number of the next row with a time larger than the current model time and a "label1" value of 4.

Table schedule = Model.find("Tools/ProcessFlow/ProcessFlow/Source>variables/arrivals");
Table result = Table.query("SELECT ROW_NUMBER FROM $1 WHERE Time > $2 AND Label1 == 4 ORDER BY Time ASC", schedule, Model.time)[1][1];
int nextRow = 0;
if(result.numRows > 0)
{
    nextRow = result[1][1];
}

Here's the documentation for global variables. Global variables are mostly what you would expect given the name. Variables you can access from anywhere in the model.

https://docs.flexsim.com/en/24.2/Reference/Tools/GlobalVariables/GlobalVariables.html

0 ·

question