How can I have arrivals from global table (in a processflow) ?

Question

question

Amel B5 asked Aug 30, '22 Jeanette F commented Sep 2, '22

How can I have arrivals from global table (in a processflow) ?

Hello,

I want to realize the reception of products in a warehouse by a processflow based on a reception global table consisting of 4 columns:

1) receiving time (Time)

2) Receiving ID

3) Product

4) Qty

when the reception time "Time" arrives, I want the quantity "Qty" of the product to be created in a reception area ( a floorstorage)

I attach the model of my problem and an image of it

I hope you can support me

Thank you

https://drive.google.com/file/d/1zUrWdSTaGe8aXTx1MUASGryAA_4siWH0/view?usp=sharing

Software Version:

FlexSim 22.2.1

processflow global table source warehouse

1661893388602.png (55.9 KiB)

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot ♦♦ commented · Aug 30, 2022 at 11:06 PM

Do you want one token per line or the quantity listed in Qty?

0 ·

Jeanette F ♦♦ commented · Sep 02, 2022 at 11:52 PM

Hi @Amel B5, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2022-08-30T23:10:03Z

Jason Lightfoot answered Aug 30, '22

Run this script to put the data in the Source:

string sql="SELECT Time,'arrivaltoken' AS Name,Qty AS Quantity, [Recep ID], SKU FROM Reception";
Table.query(sql).cloneTo(Model.find("Tools/ProcessFlow/ProcessFlow/Source>variables/arrivals"));

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question