Search the global table for the label value and return the column value

Question

question

Amanda Prado asked yesterday Gustavo Teodoro commented 1 hour ago

Search the global table for the label value and return the column value

Good afternoon everybody !

Simulation:

Warehouse Payment System, where 50 items types are paid for SPMKT. I'm creating 50 items types through 50 sources. Each source, when creating the item, already configures a label with the item's respective Part Number.

As the number of boxes for each item are different, each item has a different number of boxes that the operator picks up at a time and, for this reason, all the logic is happening in the process flow.

I have a Global Table that contains the Part Numbers and the quantities that need to be paid at a time. The point of my doubt is the following:

I'm using a list in PF to pull items according to my global table:

It turns out that there are 50 Part Numbers and I am imputing the line number for each item. I would like to know if there wouldn't be a way to make Flexsim look for the line in my table, using the label I created in the source, and return the value column, something like this, more or less:

Table("BOM")[item.(labelname)][colum] ????

As well as the load and unload locations, I am configuring them manually, but I would like you to pull, according to the label, the origin and destination location, which is also included in the Global table.

I hope I was able to be clear enough on the issue.

Thank you very much !

Yours sincerely.

Software Version:

FlexSim 24.2.1

global table

1732125386055.png (26.3 KiB)

5 |100000

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

Answer 1 · 2024-11-21T12:35:34Z

Gustavo Teodoro answered 5 hours ago Gustavo Teodoro commented 1 hour ago

An alternative approach would be to use the process flow to create the items. This way, it will not be necessary to use the 50 Sources.
In the quantity field, use the command Table("GlobalTable1").numRows, so the number of tokens created will correspond to the number of rows in your Global Table. To assign information to the token, you can reference the table and use the tokenIndex command. This command indicates the order in which the token was created and retrieves the information from each row of the table.

In the attached example, the label information includes quantity, source, and destination.
Afterward, the items are created at the destinations and in the quantities according to the information already stored in the token. These details can also be transferred to the items using the create objects command.

An example is attached.

FX_CreateObjects.fsm

1732192410049.png (92.4 KiB)

1732192476983.png (65.6 KiB)

fx-createobjects.fsm (30.8 KiB)

· 2

5 |100000

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

Amanda Prado commented · 3 hours ago

Hello Gustavo,

Your suggestion was very good. I managed to develop my model according to your idea, but I had two doubts:

1) Creating the objects in the source as you said, I can only create a limited number of items, right? The difference from creating from a 3D source is that the source can create an unlimited number of items (interarrival time 0, for example).

As my simulation is about a Warehouse that pays material to other areas, I am considering that the Warehouse always has material available and if I create a large number of items at once, my simulation crashes.

Can you think one ideia to this ?

2) I need to define the SOURCE and DESTINATION columns as "pointer", right?

But when I assign it as a pointer, I lost all the data in my table and I had to manually insert it again, because after the column is configured as a pointer, it does not accept me pasting the data again. I don't know if I'm doing something stupid.

Again, thank you very much for your help. I thought your suggestion was brilliant.

0 ·

1732201404724.png (15.1 KiB)

Gustavo Teodoro Amanda Prado commented · 1 hour ago

1) Use a circular process flow. You create itens and wait a time (delay). Then, the itens will be created again. You can set diferent time for each SKU type using Time By case function.

2) Since you are creating objects using processflow, don't use the source 3D creation, because you have already created in the process flow. Use a queue instead of a Source.

FX_CreateObjects_Manyarrivals.fsm

0 ·

fx-createobjects-manyarrivals.fsm (30.3 KiB)

Answer 2 · 2024-11-21T07:01:34Z

Felix Möhlmann answered 11 hours ago Amanda Prado commented 3 hours ago

The "getValueByKey" method does this.

https://docs.flexsim.com/en/24.2/Reference/CodingInFlexSim/FlexScriptAPIReference/Data/Table.html#Method-getValueByKey

Though I don't see a reason why you couldn't also have the row number as a token label, since using that directly will be faster than having to search the table for a matching value each time.

· 1

5 |100000

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

Amanda Prado commented · 3 hours ago

Thanks, Felix !

Using Table("TableName")[row][colum] I am able to do my logic, but I would like to use a part number label to get easier to refer in all activities, but this way I can´t do this. There are to many part numbers to input this manually in each activity that I need referecing the table.

0 ·

question