Pull item by matching label of global data table

Question

question

Jitendra Kumar asked Apr 10 2017 at 1:42 PM Jitendra Kumar commented Apr 24 2017 at 11:00 AM

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

match label backorder

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

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

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

Sam Stubbs answered Apr 10 2017 at 2:20 PM Jitendra Kumar commented Apr 24 2017 at 11:00 AM

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 3: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 3: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 9: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 2: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