This data is going into the Product Catalog. Now that I think about it --
this might work as the second record will error out and not get inserted as
AR will see it as a duplicate. While not a clean solution (will see a bunch
of errors in the import due to the failed insert of duplicates) it might
work for our purposes.
For example assume Key1 is the custom hidden field with the original key
values and ProductName is the cleaned value.
Key 1 ProductName
Dell D600 Dell D600
Dell D600 Dell D600
When AIE tries to insert the second record into the product catalog it
should error out.
.
On Thu, Aug 20, 2009 at 11:15 AM, Matt Worsdell <[email protected]> wrote:
> 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]<sponsor%[email protected]>ARSlist:
> "Where the Answers Are"
>
>
> _______________________________________________________________________________
> 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"
