question

Tamilselvan avatar image
0 Likes"
Tamilselvan asked Jason Lightfoot commented

Conditional Looping

I have imported my excel file into global table, I Have a Column name Station no and Resourse ID. I need to Search the full excel sheet and execute the time which matches my Station no and Resourse ID and exit the loop, How to do that


Thanks in advance

FlexSim 23.1.1
conditional looping
· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

What does "execute the time" mean? Perhaps upload an example and explain in a bit more detail what your want.

0 Likes 0 ·
Tamilselvan avatar image Tamilselvan Jason Lightfoot ♦♦ commented ·
I have a anothor column "Time", that time column value has to be executed
0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Tamilselvan commented ·
Do you mean the processing time of a processor/station should be read from global table?
0 Likes 0 ·

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Jason Lightfoot commented

You either use a for-loop and terminate it with "break;" as soon as you've found the correct row.

Or you use an SQL query to get the wanted value in a single command.

· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·
Or onReset or at the start write Maps onto stations for the time value, keyed on the resourceID. This will be the fastest of all methods.
0 Likes 0 ·