How to use data from a previous activity as a variable in a query in a next activity? | Community
Skip to main content
Level 4
November 2, 2021
Solved

How to use data from a previous activity as a variable in a query in a next activity?

  • November 2, 2021
  • 2 replies
  • 1020 views

Hi community,

 

We'd like to know how can i use a data obtained from a previous activity as a variable in a following activity in a workflow?.

 

From delivery logs We obtain the profiles whose i sent an especific email, and in our ACS instance we have a custom resource called purchase orders related to profiles. To send a remarketing campaign we need to send an email to profiles with no purchase order after the the date we sent the first email. Until we hadn´t been able to pass the event date as parameter in the related purchase orders.

 

This is the workflow and configurations so far

 

 

1. We obtain the delivery logs

 

 

2. We reconciliate the profiles

 

3. We add purchase data

 

 

 

and this is how we try to filter the purchase orders after the first email was sent.

 

 

Thanks in advance for any help you can give us.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

2 replies

bisswangAdobe EmployeeAccepted solution
Adobe Employee
November 4, 2021

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

Sukrity_Wadhwa
Community Manager
Community Manager
November 23, 2021

Hi @olsalas711,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!

Sukrity Wadhwa