Skip to main content
Salesforce

Return to Question

added 13 characters in body
Source Link
Gortonington
Gortonington
  • 30.9k
  • 3
  • 27
  • 64

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The issue is that the journey that runs off of the contact object is unable to bring in the opportunity ID.

I'm looking to pass the opportunity ID from one data extension over to another. I need this field "Contact:Opportunity__r:Id" (from a data extension called "Catalyst pt 1 - 2021-03-26T052629892") to be populated with the value from this field here -> "Opportunity:Id" (populated from a data extension called "New Journey - March 26 2021 1014 AM - 2021-03-26T082359570").

When I run the below I am geting errors. I was hoping to have help with what to do in order to populated one field from a data extension with information from another data extension.

INSERT INTO "Opportunity:Id" FROM ‘New Journey - March 26 2021 1014 AM - 2021-03-26T082359570’ SELECT "Contact:Opportunity__r:Id" FROM ‘Catalyst pt 1 - 2021-03-26T052629892’

INSERT INTO "Opportunity:Id"
FROM ‘New Journey - March 26 2021 1014 AM - 2021-03-26T082359570’
SELECT "Contact:Opportunity__r:Id"
FROM ‘Catalyst pt 1 - 2021-03-26T052629892’

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The issue is that the journey that runs off of the contact object is unable to bring in the opportunity ID.

I'm looking to pass the opportunity ID from one data extension over to another. I need this field "Contact:Opportunity__r:Id" (from a data extension called "Catalyst pt 1 - 2021-03-26T052629892") to be populated with the value from this field here -> "Opportunity:Id" (populated from a data extension called "New Journey - March 26 2021 1014 AM - 2021-03-26T082359570").

When I run the below I am geting errors. I was hoping to have help with what to do in order to populated one field from a data extension with information from another data extension.

INSERT INTO "Opportunity:Id" FROM ‘New Journey - March 26 2021 1014 AM - 2021-03-26T082359570’ SELECT "Contact:Opportunity__r:Id" FROM ‘Catalyst pt 1 - 2021-03-26T052629892’

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The issue is that the journey that runs off of the contact object is unable to bring in the opportunity ID.

I'm looking to pass the opportunity ID from one data extension over to another. I need this field "Contact:Opportunity__r:Id" (from a data extension called "Catalyst pt 1 - 2021-03-26T052629892") to be populated with the value from this field here -> "Opportunity:Id" (populated from a data extension called "New Journey - March 26 2021 1014 AM - 2021-03-26T082359570").

When I run the below I am geting errors. I was hoping to have help with what to do in order to populated one field from a data extension with information from another data extension.

INSERT INTO "Opportunity:Id"
FROM ‘New Journey - March 26 2021 1014 AM - 2021-03-26T082359570’
SELECT "Contact:Opportunity__r:Id"
FROM ‘Catalyst pt 1 - 2021-03-26T052629892’
Source Link
noblejp
noblejp
  • 1
  • 1
  • 1

Pushing data from one data extension to another

In Marketing Cloud, I have two data extensions. Both Data Extensions are being populated via entries in a journey. One runs off of the contact object and the other runs off the opportunity object. The issue is that the journey that runs off of the contact object is unable to bring in the opportunity ID.

I'm looking to pass the opportunity ID from one data extension over to another. I need this field "Contact:Opportunity__r:Id" (from a data extension called "Catalyst pt 1 - 2021-03-26T052629892") to be populated with the value from this field here -> "Opportunity:Id" (populated from a data extension called "New Journey - March 26 2021 1014 AM - 2021-03-26T082359570").

When I run the below I am geting errors. I was hoping to have help with what to do in order to populated one field from a data extension with information from another data extension.

INSERT INTO "Opportunity:Id" FROM ‘New Journey - March 26 2021 1014 AM - 2021-03-26T082359570’ SELECT "Contact:Opportunity__r:Id" FROM ‘Catalyst pt 1 - 2021-03-26T052629892’