Pull item by matching label of global data table

Question

question

Jitendra Kumar asked Apr 10, '17 Jitendra Kumar commented Apr 24, '17

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

Software Version:

FlexSim 17.0.2

backorder match label

pull-item-by-global-table-label-match.fsm (26.7 KiB)

Answer 1 · 2017-04-10T14:20:15Z

Sam Stubbs answered Apr 10, '17 Jitendra Kumar commented Apr 24, '17

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

Jitendra Kumar commented · Apr 11, 2017 at 03:09 PM

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 ·

pull-item-by-global-table-label-match2.fsm (38.6 KiB)

Sam Stubbs ♦ Jitendra Kumar commented · Apr 11, 2017 at 03:21 PM

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 ·

Jitendra Kumar commented · Apr 13, 2017 at 09:59 AM

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 ·

Sam Stubbs ♦ Jitendra Kumar commented · Apr 13, 2017 at 02:02 PM

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 ·

6241-pull-item-by-global-table-label-match-1.fsm (31.7 KiB)

Jitendra Kumar Sam Stubbs ♦ commented · Apr 24, 2017 at 11:00 AM

Thank you very much

0 ·

question