AnsweredAssumed Answered

How to ignore entries when the item is not in the CACHE

Question asked by mrelzer on Feb 27, 2018
Latest reply on Mar 1, 2018 by Srinivas Chandrakanth Vangari

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.

 

Outcomes