Advanced join Condition in Enrichment Usage

[Rishabh46]

Hi,

We are trying to use the Advanced join as shown above to a temporary table but we are getting Sql error at the time of delivery is trigger

The error shown below screenshot

However, if we use the Simple join it works perfectly

Please help us in understanding how to implement Advance join

Any reference document would also be fine

Thanks

Rishabh

[bhaveshp8596869]

Hey Rishabh46,

Can you provide the logs within the Delivery Audit, have you added any additional fields as personalization? Has the delivery been created? Is this error after it was created, or before it hits that activity. Have you enabled any SQL logging? Is so, please provide this so we can look at what tables are throwing this error.

Thanks!

Bhav