http://forums.visokio.com/discussions/tagged/min/feed.rss Mon, 30 Oct 17 18:15:59 -0400 Tagged with min - Visokio Forums en-CA http://forums.visokio.com/discussion/2902/merge-assigning-data-into-bandss Tue, 07 Apr 2015 12:24:51 -0400 DarrenElding 2902@/discussions
I have a shipment file with a list of shipments of different weights. I have a second data table with a list of weights alongside the weight band descriptions, e.g. 0kg = 0-5kg, 5kg = 5-10kg, 10kg = 10-30kg, etc. I want to merge the weight band description field into the shipment file so that, for example, a 25kg shipment is assigned to the 10-30kg weight band. The problem is that in the merge function if I select the shipment weight to be 'greater or equal to' the weight in the weight band file I get a many to many error as a 25kg shipment is greater than 10 so falls into the 10-30kg band but is also greater than 5kg so also falls into the 5-10kg band.

Is there a way I can get it to assign only the 'highest' weight band in which the shipment falls and not every weight band below that as well?

Many thanks

Darren]]>