I don't think you can do it in the Primary Field Mapping. You can qualify the query, however. In my data exchanges for people I break up the processes for updating 200,000 records into 20,000 record chunks by having separate exchanges and form mappings for each possible number, 0 to 9, the ends an employee ID from PeopleSoft. The qualification placed in the Query - Data Key Query - External Data Store Query field is RIGHT(workforceid,1) = N, where N is a number 0 to 9 depending on which mapping and exchange is defined.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Adam Laubach Sent: Thursday, August 20, 2009 9:29 AM 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"
