How to set the query of replenishing items from multiple racks?

Question

question

sara S2 asked Feb 25, '20 sara S2 commented Mar 7, '20

How to set the query of replenishing items from multiple racks?

Hello,

I want that each operator loads items from the rack beside in the "ProcessFlow2". If the loaded quantity is not enough then the operator can complete it by loading from the other rack. I start by the condition 'loading from the rack beside'. I added the field "LRackN" in the list4 that attributes to each pushed item a value of 3 if this item belongs to "rack 31" and the value 4 if it belongs to the "rack19". In addition, I put the query "WHERE LRackN = 3" in "pull from list1" and the query "WHERE LRackN = 4" in "pull from list2". But, this is not working for the operator 2!

Would anyone tell me why I get this problem, please?

Regards.

trying1.fsm

Software Version:

FlexSim 19.0.0

process flow

trying1.fsm (118.6 KiB)

Answer 1 · 2020-02-25T19:04:55Z

tannerp answered Feb 25, '20 sara S2 commented Mar 7, '20

@sara S2,

My first guess as to why this doesn't work is that the Pull from List2 activity is trying to pull items based on the query: "WHERE LRackN = 4".

This would work, but there aren't items with a LRackN label of "4" on the list. Maybe there's something that's supposed to be there, but it's not. Did you intend to have items with a LRackN label of "4"?

lrackn-4.png (61.6 KiB)

· 3

sara S2 commented · Feb 25, 2020 at 08:06 PM

Thank you @tanner.p for your reply.

I found the problem. It is taking only the value 3 because I set "value.type" in the field “LRackN” of the “list4” (FIG). While “type” is taking values from 1 to 8 only.

I should set a label instead of global table value in this field. This label value must depend on the existing racks (Now I have 2, but it could increase). So, I need to set this label on each item (box) entering a rack, this label will take the number that corresponds to the concerned rack (for exp: 3 for the “rack31” and 4 for the “rack19”).

How could I do this? Please help me to fix this.

fig.png

0 ·

fig.png (176.6 KiB)

tannerp sara S2 commented · Mar 05, 2020 at 09:25 PM

@sara S2,

You could create a table that indicates which rack is associated with Type label. The rows would be correlated to the "Type" and then the first and only column would contain the rack names. Then you could use an Assign Labels activity to look up a value from the table and assign it to the token. Hopefully I've understood your question correctly.

1 ·

type-table-lookup.png (35.0 KiB)

sara S2 tannerp commented · Mar 07, 2020 at 04:31 PM

@tanner.p thank you for your help.

0 ·

question