++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
What you may need to do is to create a database view on your source data which will contain function(s) that remove the leading/trailing spaces. The view will then be your data source for AIE. Hope this helps. Jiri Pospisil LCH.Clearnet -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Adam Laubach Sent: 20 August 2009 15:29 To: [email protected] Subject: AIE Primary Key Mapping - Functions Allowed? Is it possible to use a function in a primary key mapping in AIE? It does not appear that you can. Tried manually typing a function in the mapping and it errors out. The reason I ask is the field I need to map as the key has some values with leading/trailing spaces. It is causing some dups as AIE does not see them as the same value due to the spaces. I would like to remove them before AIE evaluates the key. I assume there has to be a solution to this as it is rather common to find issues in source data. Also compund keys need to be used in some integrations and a function makes it easy to implement. Another thought I had was to see if AIE allowed a SQL query as a data source and remove them that way, but it appears it only allows tables or views to be a data source. ARS : 7.1.0 patch 005 AIE : 7.1.0 patch 006 The data source is SQL server. Thanks in advance for any assistance. -- Sent from my mobile device _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [email protected]. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
