I don't believe it does. You could of course map the key to a hidden field to respect the data integrity, then in the mapping use a function to display the cleaned value to the end user.
Matt -----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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
