[Solved] AMPScript gives an error about not able to find an attribute

Daan Kramer Asks: AMPScript gives an error about not able to find an attribute
I am trying to retrieve data from a synchronised data extension with AMPScript . I have a field named Contact__c which contains the contactID. This contactID is connected to zero, one or multiple product interests (URL_Monthly__c). The product interests are displayed as an URL (<a href>).

I want to create an e-mail where the URL’s are generated based on the contactID. I have the following AMPScript:


VAR @multiRows, @row, @i, @URL_Monthly__c, @Contact__c

SET @Contact__c = AttributeValue("Subscriber Key")
SET @multiRows = LookupRows("Fund_Interest__c_Salesforce",@Contact__c,Id)

    for @i = 1 to RowCount(@multiRows) do 
       Set @row = Row(@multiRows,@i) 
       Set @URL_Monthly__c = Field(@row,"URL_Monthly__c") ]%%

%%[ Output(v(@URL_Monthly__c)) ]%%
%%[ next @i ]%%


This AMPScript gives me the following error:

The specified attribute or custom object field name was not found for this client. Function Call: LookupRows(“Fund_Interest__c_Salesforce”,@Contact__c,Id) Attribute or Field Name: “Fund_Interest__c_Salesforce”

What am i doing wrong?

Ten-tools.com may not be responsible for the answers or solutions given to any question asked by the users. All Answers or responses are user generated answers and we do not have proof of its validity or correctness. Please vote for the answer that helped you in order to help others find out which is the most helpful answer. Questions labeled as solved may be solved or may not be solved depending on the type of question and the date posted for some posts may be scheduled to be deleted periodically. Do not hesitate to share your response here to help other visitors like you. Thank you, Ten-tools.