question

sara S2 avatar image
0 Likes"
sara S2 asked sara S2 commented

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

FlexSim 19.0.0
process flow
trying1.fsm (118.6 KiB)
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.

1 Answer

tannerp avatar image
0 Likes"
tannerp answered sara S2 commented

@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
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.

sara S2 avatar image sara S2 commented ·

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 Likes 0 ·
fig.png (176.6 KiB)
tannerp avatar image tannerp sara S2 commented ·

@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 Like 1 ·
type-table-lookup.png (35.0 KiB)
sara S2 avatar image sara S2 tannerp commented ·

@tanner.p thank you for your help.

0 Likes 0 ·