question

Jitendra Kumar avatar image
0 Likes"
Jitendra Kumar asked Jitendra Kumar commented

Pull item by matching label of global data table

Hi,

I have a small model, source, queue, processor and exit. Flow items are generated using a schedule and stored at queue, each flow item is having some labels as PART_COL_ID and PART_COL. Now I want to pull the flow items at processor based on a global preference table "GlobalTable1. This table consist of two labels as PART_COL_ID and PART_COL of each flow item.

I will take the first flow item from global table and look for it in queue by matching label PART_COL_ID, if I found match I will send it processor and removed it from GlobalTable1, if not I will look for substitute by matching label PART_COL in queue, even if I not found match, I will keep the flow item as back order and look for next flow item of global table.

Any help, thread will be appreciated. I am attaching my model.

Thank you in advance

Jitendra

pull-item-by-global-table-label-match.fsm

FlexSim 17.0.2
backordermatch label
pull-item-by-global-table-label-match.fsm (26.7 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

Sam Stubbs avatar image
1 Like"
Sam Stubbs answered Jitendra Kumar commented

I think if you set up your system with Lists it will work better. If you are unfamiliar with lists I recommend going to the User Manual > Modeling Tools > Lists section and reading up about them. Essentially what you will want to do is push the items to a list when they enter the queue. Also I'd recommend going through the Process Flow tutorials in the manual, there's a chapter there that covers using lists in the Process Flow environment.

Then you'd want to set up some Pull system to pull from the list using query. Your query would look something like this: WHERE PART_COL_ID = Puller.PART_COL_ID.

I tried to modify your example with a simple set up like this. You may need to adjust the model to better suit what you are looking for, but at least it will give you an idea of how to set this up.

pull-item-by-global-table-label-match-1.fsm


pull-item-by-global-table-label-match-1.fsm (31.4 KiB)
· 5
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.

Jitendra Kumar avatar image Jitendra Kumar commented ·

Hi @Sam Stubbs

Thank you, I have tried to use list section, and use process flow, I just stuck in query section of "Pull from ItemList1". How it will read or fatch first item of GlobalTable1 and search in ItemList1 ?

Regards,

Jitendra

0 Likes 0 ·
pull-item-by-global-table-label-match2.fsm (38.6 KiB)
Sam Stubbs avatar image Sam Stubbs ♦ Jitendra Kumar commented ·

The Request and Require number are how many items being pulled, not the serial number. If you want to look up by serial number you need to add a query line. Please see my previously attached model as an example.

0 Likes 0 ·
Jitendra Kumar avatar image Jitendra Kumar commented ·

Hi @Sam Stubbs, thanks for your help, In this model the processor is waiting till 2000 minutes for the first item of GlobalTable1, it is not looking for another items during that time. I need my processor to pull the items using Globaltable1 sequence subjected to minimum sequence disruption. e.g. in sequence if the flowitem yet not came in queue, it should look for another flowitems of global table. and pushes old flowitems in as back order. A soon as old flowitems are available in queue, processor should give priority to them.

0 Likes 0 ·
Sam Stubbs avatar image Sam Stubbs ♦ Jitendra Kumar commented ·

That's when you could use something like a Max wait timer on your Pull from list activity. Set it up so that it tries to pull the item based on the serial ID, but then set it so that after a certain time (which could even be 0 seconds) then it just moves on to another activity, in this case just another Pull activity but with no requirement, so it will just grab the next thing on the list.

Here's an updated example. It waits for 20 seconds as an example, before just grabbing the next item on the list.

6241-pull-item-by-global-table-label-match-1.fsm

0 Likes 0 ·
6241-pull-item-by-global-table-label-match-1.fsm (31.7 KiB)
Jitendra Kumar avatar image Jitendra Kumar Sam Stubbs ♦ commented ·

Thank you very much

0 Likes 0 ·