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
Shouldn't the decision shape lookup what's already in the document cache to see if it's the unique ID already exists?