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"
