R
rjreilly
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!
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!