Boomi Buzz: Blogs & Events
Boomi Training & Certification
About the Community
to create and rate content, and to follow, bookmark, and share content with other members.
How to validate duplicate rows coming in the Flat file?
Question asked by
on Mar 3, 2015
on Mar 4, 2015 by MuhammadSiddiqui3221
I have a scenario to check the duplicate records with exact match coming in the flat file within multiple rows
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 3 comments
(Required, will not be published)
Mar 4, 2015 4:59 PM
Is the goal to throw away duplicate records? This answer may meet your needs:
Do you want to check for a match against every single field (i.e., if every single field is the same, it is a duplicate)? Or might there be a handful of fields that constitute a duplicate?
Mar 4, 2015 5:00 PM
Here is a way to evaluate the entire record for duplicates:
Mar 4, 2015 6:00 PM
The goal is to match two records on the basis of 4 fields and the logic to implement is do not process part of the record. So in a way i need to build a logic to mark such records in the profile rather throw that duplicate as we dont have a full match scenario where your solution is best fit.
Retrieving data ...
Assigning multiple values to the same filed in the mapping to the target profile
PGP Encrypt in Boomi last too long
How Do I 'Blank' Out a Field in an Application Request?
Salesforce Integration Guide
Message queuing issues on Cloud atoms