I want to use this table for taking the values from the 2nd column and giving that value to a Process Flow label. And I also want to use these values in the source, like create by percentage, but i want to reference to global table
Answer by Matthew Gillespie ·
You should use the dempirical command. You already have the global table set up correctly.
This command uses the first column for percentage values and the second column for return values.
You can also use the empirical and cempirical commands, which are similar but include some interpolation between values.
See the attached model.
Answer by Emily Hardy ·
One way to do this is to create a trigger that sets the Item Type upon creation based on percentage, and then sample the global table.
You can also sample the Type if you would like. I've attached a sample model with the above logic that also changes the color depending on the Type. Hope this helps!