Thanks for the suggestions. I have already though of this option, but unfortunately I don't think we have the option of modifying the source views.
My other idea is to dump the data into a staging table in ARS, have filters modify the data and then import the cleaned data. Just seems to me that this is a common issue in integrating data from external sources -- a little surprised that there is not a built in way to transform the key data. On Thu, Aug 20, 2009 at 11:34 AM, Jiri Pospisil < [email protected]> wrote: > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > 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]<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]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
