How to get dempirical label assignment function to recognize string?

Question

question

Joey A asked Mar 21, '24 Joey A commented Mar 25, '24

How to get dempirical label assignment function to recognize string?

Hi,

In my "Create Object" process flow I am trying to get a sku label based on a dempirical distribution. I keep getting 0 for my "Sku" label and I can't figure out why. I changed my "Sku" values from values with consonants (I'm assuming they are being seen as strings) to integers in my excel sheet and the function started working. I'm assuming the dempirical function I'm using doesn't like string values.

Function: dempirical("IB_Dempirical")

How can I get the dempirical function to assign a string value for my "sku" label?

Thank you for any help you can provide!

Joey

dempirical help.fsm

Software Version:

FlexSim 23.0.5

dempirical strings empirical table

dempirical-help.fsm (90.8 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.

Answer 1 · 2024-03-22T08:00:07Z

Felix Möhlmann answered Mar 22, '24 Joey A commented Mar 25, '24

As you say, the function only numeric values (despite the documentation never explicitly stating this). You could store the string values in a third column, have the distribution return the row number and then read the respective value from the extra column.

1711094376885.png (16.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.

Joey A commented · Mar 25 at 02:06 PM

Thank you!!!

0 ·

question