I'm getting pretty frustrated with an issue... here is my flow:
I'm taking an IDOC (XML Profile) and :
- Splitting by Handing Units (and caching it) -- This appears to be working great.
- Splitting by Serial Numbers (and caching it) -- This appears to be working great.
- Mapping Handling Units (Carton) and Serial. Splitting the document. Dropping all serials that aren't linked to a carton. Combining the documents. Then caching the result. -- This appears to be working great.
- In step 4... I'm taking the original IDOC, and building data in to three tables (database profile). In the third table, I need to create a record only if the serial number in question is matched to a Carton. So I am using a document cache lookup
The lookup works... however Boomi adds a blank record to this table for all items from the origin profile that fails (doesn't find a match) in the document cache lookup.
Is there any way to defeat this, so that a failure in the lookup doesn't create a record?
Here is a piece of the output -- I don't want the records where CARTON and SERIAL are empty.