Limiting Part Numbers with a Join

It’s common to want to limit (or “filter”) a segment to a set of part numbers using a join between two data sources. For example, you might have a price sheet with prices for all parts and want to limit the parts in the script to a smaller list of parts for a particular trading partner.

The join feature in PIESCentral expects a single child record for each parent.

For the description segment you could make the smaller list of parts the master and the parent of the join without a problem because there is just one description row for each part.

For the Pricing, Attribute, Package, Kit and Interchange segments, however, this doesn’t work because you would have multiple child records for each part.

It’s very easy to work around this requirement. Simply reverse the join and change the master source. For example, in the pricing segment, make the full price sheet the master source and the parent of the join. Make the smaller list of parts the child of the join and check “Remove null rows”.