Conditional logic - trick question
I get regular data runs contain 2 fields, product and date, where unique
combinations thereof amount to batches. the dates can and do change.
Products can move on and off the list.
I am looking for a solution to review the the 2 arrays and determine the
numver of unique combinations and based on chronoligical order of date past
to future return the name of the product and a batch number. "Apples 2"
would be the second of unique combinations of product Apples and date. There
may be 2 there may be 20 combinations, depending on any individual datra run.
And where Product appears without a date I am looking for Product name
followed by "unscheduled" instead of a batch number (foe example; "Apples
Unscheduled"). "Pears 1" would be the first or unique combination for
product Pears.
Thank you in advance!
|