Hi all, Our scenario:
Bringing in an external spreadsheet of 5 fields. Once brought into the staged dataset via AIE the records are normalized and reconciled into the BMC.Asset Dataset. We are utilizing Name to identify on in ComputerSystem. Issue: Because this spreadsheet is completely human entered and not an export from any system there is a chance of human error. We would like to ensure that if a Name is incorrectly input into the spreadsheet it is not reconciled into the CMDB. Question: How to I exclude a record from reconciliation into BMC.ASSET if it DOES NOT currently exist (from the staged dataset). Thank you, have a great day. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"