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.