AnsweredAssumed Answered

Removing duplicates prior to document cache

Question asked by paulpham on Dec 27, 2017
Latest reply on Jan 10, 2018 by mmorthala189353

Hello,

 

I'm looking for help on getting unique records into my document cache. I have an xml document which I have split by 'User ID' field. Unfortunately, there happens to be duplicates based of the User ID field. I'm looking to to take the 1st occurrence of this user id field and place the document in a cache. I have tried the following method:

- Split xml, flow control (individual documents), decision shape on the lookup (see below)

** Output parameter is User ID and Parameter value is XML Profile - User ID field of current document

 

Error: 

 

Shouldn't the decision shape lookup what's already in the document cache to see if it's the unique ID already exists?

 

Thanks,

Paul

Outcomes