1

I've encountered an issue while using a LookUp function in AMPscript in an email. I get the error "Failed to convert parameter value from a string to a Int32", when trying to LookUp a value using an id I retrieved from another Data Extension. Our LookUp looks like this:

/* this LookUp has no issue, the recommendation1 column has a Numeric datatype */
SET @recommendation1 = LookUp("users", "recommendation1", "subscriberKey", _subscriberkey)

/* The id column in the Productfeed also has a Numeric datatype */
SET @country = LookUp("ProductFeed", "country", "id", @recommendation1)

The columns I use for the retrieve and the columns I use for the WHERE clause all have Numeric as datatype, so why am I getting a "cannot parse string to int32" error? Thanks in advance.

0

Check out this answer:

Getting an error Failed to convert parameter value from a String to a Int32

It seems that you are passing a string into a number field before the two lookups in your question..

| improve this answer | |
  • Hi Rachid, thanks for your answer. I can't see where we're passing a string from. As the column we want to use in the WHERE clause and the value we use in the WHERE clause are both Numeric in their Data Extensions. – Rutger Nov 8 '19 at 10:39
  • Can you past all AMScript code? It will be easier to identify the problem.. – Rachid Mamai Nov 8 '19 at 10:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.