build upstream of a small Pill Bottles manufacturing facility, there are four different pill types of drugs
“A, “B”, “C”, and “D”
All the labels (the Bottles’ information) will depend on the transactional data and will be assigned to each Pill Bottle once it is created
At first the “PillBottleGenerator” will create the Pill Bottles depending on their arrival time and their color that is in the “Color” column in the transactional data
Create the Pill Bottles depending on their color that is in the “Color” column in the transactional data
The colors are (blue, brown , green, orange, pink, purple, red, yellow)
I have created the generator, and from the flow item bin I picked a pill bottle
but I am struggling in how to match the colors for the bottles with the transactional table that contains the arrival time, drugtype(string), quantity (integer)
and how to make the color changes depending on the arrival time specifically