Why can't i use global table replace number in Query of pull list ?

Question

question

Anan Y4 asked Aug 21, '20 Jeff Nordgren commented Aug 21, '20

Why can't i use global table replace number in Query of pull list ?

When i use global table replace number in Query Tab, it will error. My objective is value of type must change by value of token.customer Which must lookup value in global table But When use use global table replace number it will error. Help me please.

Software Version:

FlexSim 20.1.1

rack query flexsim 20.1.1 puller

query-1.png (163.9 KiB)

pull-list-from-rack.fsm (47.7 KiB)

· 1

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.

Jeff Nordgren commented · Aug 21, 2020 at 02:59 PM

Hi @anan.y4, was @joerg.vogel's answer helpful? If so, please click the red "Accept" button on their answer!

1 ·

Answer 1 · 2020-08-21T04:25:02Z

Joerg Vogel answered Aug 21, '20 Joerg Vogel edited Aug 21, '20

EDIT: My suggestion to use something like that doesn't work.

WHERE Type = Table(“GlobalTable1”)[puller.customer][1]

You have to assign the value of the table cell to another token label. Then you use this label in your condition.

But you still need to parse a token reference as the variable puller in your query:

WHERE Type = puller.tableCell

tablecell-value-as-puller.png (13.1 KiB)

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