Counting SKU type in queue and pulling the one having max content?

Question

question

Ankur A3 asked Sep 18, '23 Ankur A3 commented Sep 18, '23

Counting SKU type in queue and pulling the one having max content?

Hi Team,

I am creating a model where there are multiple SKUs generated randomly in queue. I have to select the SKU having max content to pull from list 1 by 1. This sequence will continue until all the item gets over for the selected SKU. Now, next SKU will be chosen based on its content in list.

Also, how can I get the # of SKU available in the queue at a given time?

I would like to know the best way to approach this problem.

Thank you!

List_Content_Count_Trial.fsm

Software Version:

FlexSim 23.1.0

queue content count sku

list-content-count-trial.fsm (46.3 KiB)

Answer 1 · 2023-09-18T12:34:07Z

Jason Lightfoot answered Sep 18, '23 Ankur A3 commented Sep 18, '23

This interpretation takes all of the matching types until there are none remaining and uses a table query to find the type with the maximum (by removing the list partitions)

Table result=Table.query("SELECT Type,count(*) AS Total FROM ItemList1 GROUP BY Type ORDER BY Total DESC");

list-content-count-trial_jl.fsm

1695040391031.png (17.9 KiB)

list-content-count-trial-jl.fsm (47.9 KiB)

· 1

Ankur A3 commented · Sep 18, 2023 at 03:04 PM

Thank you so much! @Jason Lightfoot

It's working well. The learning for me is to see that we can also use list as global table to apply SQL query which makes it simple.

Thank you once again for your quick response.

0 ·

question