I've tried a few of the hints here to solve this one elegantly but can't quite get there.
I have two sources of data. One is "used" and the other is "valid" - the values in "valid" contain ranges of numbers for product IDs, whilst the "used" source is what is actually sitting in an inventory system.
A "valid" value for a product ID could be something starting with:
0231 0232 049 073And in the actual "used" data I have product IDs such as:
0231930128 023183818 074432131234 8313952
What I'm looking for is a way to extract out the values of product IDs for which there's no value prefix in the valid source to match. In this simple example, the 074432131234 and 8313952 entries (I want the entire event, not JUST this field) should appear, but not the first two.
I've tried various games with eval, tables to assign "Y" values, comparing the two, join inner, join outer, but there must be a better and easier way.
asked 29 Feb '12, 23:20