How can I join to the Address table to identify the quarantines so I can eliminate them from the population prior to the delivery?
The way the workflow is currently written, we read an imported table that contains the recipient ID, change dimension to recipient table, then eliminate quarantines. I'm not finding the correct join method to get to the Status field in the Address table. Every way I've tried ends in Status 4 cannot be resolved. Thanks.
Hi @n235ps ,
After changing the dimension to recipient (Recipient as Targeting dimension), try the below workflow logic,
Enrichment:
Add data > a link >
Link type: Define a link whose target may not exist in database
Link Target: Database schema
target schema: nms:address
Next > Use a simple join,
If you are performing Email campaign,
Source expression: [target/@email]
Destination expression: @address
> Finish
Whereas, if you do SMS campaign, select source as [target/@mobilePhone]
Save the workflow, open 'Enrichment' activity again, Edit additional data > add [address/@status] in output columns.
Split:
General tab > configure as below
Subsets tab > select 'Add a filtering condition' radio button > Edit >
@status EQUALS TO Quarantine
Connect delivery to the complement transition of Split activity.
So all the quarantine records will be eliminated prior to the delivery.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.